Re: help: pass the parameter to the pl/sql

On Tue, 15 Jan 2002 20:10:04 GMT,
u518615722_at_spawnkill.ip-mobilphone.net (Mike F) wrote:

>we need to pass our parameter into our pl/sql
>
>-----------------
>create or replace procedure error_log_archive
> (SCHEMA in varchar2)
>as
> sensor_rec SCHEMA.sp_error_log%ROWTYPE;
> CURSOR A is
> select s.* from SCHEMA.Col1 s
> where
> bla bla;
>-------------------------------------
>
>but oracle does not allow us to do so, could somebody help me out?
>
>Thanks
>

No version, as usual
In 8i and above, you need to use Native Dynamic SQL (Open <refcursor var> for :sqlstatement) In 8.0 and before you need to use dbms_sql.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jan 15 2002 - 14:46:19 CST