Results 1 to 4 of 4

Thread: Getting data back from a Stored Procedure in Oracle

  1. #1
    Geek_Guest
    Guest

    Getting data back from a Stored Procedure in Oracle

    I'm having problems getting data back from a stored procedure in oracle.
    I parse an input file and take out one field. CompanyID. I then run a stored procedure that is very simple: select address, name1 from company where cid=:CompanyID.

    No mater how simple, i keep getting PL/SQL buffer issues. If anybody could point me in the right direction, or where to dig a little deeper, it would be greatly appreciated.

    Question asked by visitor neal jasinski


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Getting data back from a Stored Procedure in Oracle

    can you please post your code with table structure for my reference .


  3. #3
    Junior Member
    Join Date
    Jun 2007
    Answers
    18

    Re: Getting data back from a Stored Procedure in Oracle

    Are u trying to get the data in an out variable or could u please post the code


  4. #4
    Junior Member
    Join Date
    Aug 2007
    Answers
    1

    Re: Getting data back from a Stored Procedure in Oracle

    if u r trying to get the data back with the help of an OUT parameter, and the version of oracle is pre oracle8i it will not allow do that.
    it s possible to assign a new value to your out parameter in later version.
    if thats not hte issue plz mention in detail whether u want out param value top be taken from the block or what?


  5.  Sponsored Ads
    Ad


     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact