Reference Cursor and wrap utility [message #38211] |
Mon, 01 April 2002 22:28 |
anoop
Messages: 15 Registered: October 2001
|
Junior Member |
|
|
I am successful in wrapping all my sps using wrap utility. But I have an sp that has reference cursor
like
OPEN cursor_rpt FOR lstr_select
where lstr_select contains the select statement. Now wrap gives an errors saying that it expects a select after FOR..
Pls advice what to do. Thax
|
|
|
|
Re: Reference Cursor and wrap utility [message #38219 is a reply to message #38211] |
Tue, 02 April 2002 22:29 |
anoop
Messages: 15 Registered: October 2001
|
Junior Member |
|
|
Hi Todd,
Answer to ur queries are
1 Oracle Server 8.1.6
and Oracle Client 8.1.7
2 The sp is getting compiled and behaving normally when being executed. The variable cannot be relaced by the query as the query is generated dynamically.
We have tried the following
a. repalced the variable lstr_select with
'select ......' using a,..
ie replacing variable lstr_select with the query
b. tried to declare the cursor as
lcur_a is ref cursor returns tablefieldtype;
Waiting in Anticipation
Rgrs,.. Anoop
|
|
|
|