execute immediate in Oracle 10g reports? [message #117612] |
Thu, 28 April 2005 09:23 |
jsg1
Messages: 8 Registered: April 2005
|
Junior Member |
|
|
Can i use execute immediate in a function within a library for oracle 10g reports?
i.e.
execute immediate 'SELECT ' || p_vc2_seq_name || '_' ||p_vc2_report_id ||'.NEXTVAL FROM dual' into l_n_seq_no;
When I compile the above within a Program unit in reports - I get message -
Error 591 at line x, column y
this feature is not supported in client-side programs
If I cannot do the above - any suggestions would be appreciated on how to execute the above select statement.
|
|
|
|
|
Re: execute immediate in Oracle 10g reports? [message #118174 is a reply to message #118159] |
Tue, 03 May 2005 08:33 |
jsg1
Messages: 8 Registered: April 2005
|
Junior Member |
|
|
Thanks.
I have tried DMBS_SQL within Oracle 10g reports -
l_vc2_sql_text := 'SELECT ' || p_vc2_seq_name || '_' ||p_vc2_report_id ||'.NEXTVAL FROM dual';
l_n_cursor_id := dbms_sql.open_cursor;
dbms_sql.parse(l_n_cursor_id, l_vc2_sql_text,dbms_sql.native);
l_n_seq_no := dbms_sql.EXECUTE(l_n_cursor_id);
dbms_sql.close_cursor(l_n_cursor_id);
but unable to compile due to the following -
'Implementation restriction 'DBMS_SQL.NATIVE': cannot directly access remote package variable or cursor'
Can anyone help me to solve the above problem within a reports Libaary?
jsg1
|
|
|
|
|
|