Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Returning a ref cursor with dynamic SQL in PL/SQL
> vv_sql_statement :=
> 'SELECT *
> FROM ssr_person_report_view
> WHERE cdas_sales_id IN :sales_ids
> ORDER BY cdas_sales_id
> , order_details';
>
> open vr_person_report for vv_sql_statement;
>
>
> your syntax before was wrong.
Actually, it hasn't worked.
I cannot compile the package now; I get the following error:
PLS-00455: cursor 'VR_PERSON_REPORT' cannot be used in dynamic SQL OPEN statement
vv_sql_statement := 'SELECT * FROM ssr_person_report_view WHERE cdas_sales_id IN :sales_ids ORDER BY cdas_sales_id , order_details '; OPEN vr_person_report FOR vv_sql_statement; EXECUTE IMMEDIATE vv_sql_statement USING vv_sales_ids;
Mark Received on Tue Nov 26 2002 - 02:31:07 CST