Getting data back from a Stored Procedure in Oracle

[Geek_Guest]

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

[debasisdas]

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

[soorajsk_84]

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

[hi2anup]

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?