Home » SQL & PL/SQL » SQL & PL/SQL » problem while executing Ref cusror (oracle 10g,)
problem while executing Ref cusror [message #332471] Tue, 08 July 2008 11:16 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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
Re: problem while executing Ref cusror [message #332475 is a reply to message #332471] Tue, 08 July 2008 11:24 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: problem while executing Ref cusror [message #332480 is a reply to message #332471] Tue, 08 July 2008 11:37 Go to previous messageGo to next message
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
Re: problem while executing Ref cusror [message #332484 is a reply to message #332471] Tue, 08 July 2008 11:44 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use an array of values instead of a single string.

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


Current Time: Thu Dec 08 02:31:29 CST 2016

Total time taken to generate the page: 0.12332 seconds