OraFAQ Forum: SQL & PL/SQL » output parameter

Home » SQL & PL/SQL » SQL & PL/SQL » output parameter

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

output parameter [message #9673]

Sat, 29 November 2003 01:35

Srinath
Messages: 40
Registered: May 2002

Member

Hi All:

I have a procedure in which i declare an output parameter as varchar2 and i expect the output more than the limit of varchar2 can you please specify any other datatype which i can use here....it should be compatible with functions like substring etc....

Thanks in advance
Srinath

Report message to a moderator

Re: output parameter [message #9675 is a reply to message #9673]

Sat, 29 November 2003 10:10

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Remember that the VARCHAR2 parameter can go up to 32K - it is not limited to 4K.

Report message to a moderator

Previous Topic:	NLS information
Next Topic:	Database connection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 03:23:58 CDT 2024