Printable View
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.
[b]Question asked by visitor neal jasinski[/b]
can you please post your code with table structure for my reference .
Are u trying to get the data in an out variable or could u please post the code
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?