OraFAQ Forum: SQL & PL/SQL » problem while executing Ref cusror

Home » SQL & PL/SQL » SQL & PL/SQL » problem while executing Ref cusror (oracle 10g,)

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

problem while executing Ref cusror [message #332471]

Tue, 08 July 2008 11:16

ramanajv1968
Messages: 168
Registered: December 2005
Location: HYDERABAD

Senior Member

Hi All,

Below is the sample code :

Procedure P1(V_in clob) is

where V_in is the select query.

Quote:

For my procedure I am getting a select query as an input string.
And by using ref cursor I am executing that query and fetching the values into a table type and using.

But when ever the syze of the input select query exceds the 32,767 then I am getting the pl/sql numric error.
how can I handle such scenarios. as the select state is variets dynamically,

Thanks,

[Updated on: Tue, 08 July 2008 11:32] by Moderator

Report message to a moderator

Re: problem while executing Ref cusror [message #332472 is a reply to message #332471]

Tue, 08 July 2008 11:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Report message to a moderator

Re: problem while executing Ref cusror [message #332475 is a reply to message #332471]

Tue, 08 July 2008 11:24

ramanajv1968
Messages: 168
Registered: December 2005
Location: HYDERABAD

Senior Member

Yes I do agree that my post is not proper formated not even having the sample code(sorry for that).
But this issue is an urgent and if any help in this regard is greatly appreciable.

Thanks,

[Updated on: Tue, 08 July 2008 11:24]

Report message to a moderator

Re: problem while executing Ref cusror [message #332477 is a reply to message #332471]

Tue, 08 July 2008 11:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Quote:

But this issue is an urgent

please elaborate why it is urgent for ME to solve this problem for you.

You can have the solution, good, fast or cheap. Pick any 2.

Report message to a moderator

Re: problem while executing Ref cusror [message #332480 is a reply to message #332471]

Tue, 08 July 2008 11:37

S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom

Senior Member

Quote:

But this issue is an urgent

Please don't use this word in any forums as it always attracts wrong attention.
Check this link for more information.
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_dynamic_sql.htm#BJEDICBD
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sql.htm#sthref6136

Regards

Raj

Report message to a moderator

Re: problem while executing Ref cusror [message #332484 is a reply to message #332471]

Tue, 08 July 2008 11:44

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use an array of values instead of a single string.

Regards
Michel

Report message to a moderator

Previous Topic:	drop and recreate new partition
Next Topic:	Extract number digits from varchar and converting it to a number

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 10 02:25:58 CST 2024