Re: pass the parameter to the pl/sql

Mike,

A clarification, please. Are you trying to write a sp (stored procedure) that accepts different schemas to operate on. That is, a procedure that can be run against tables from multiple owners?

• Christopher

"Mike F" <u518615722_at_spawnkill.ip-mobilphone.net> wrote in message news:l.1011125405.1921936035@[64.94.198.252]...
> 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
>
>
>
>
> --
> Sent by dbadba62 from hotmail in area com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Tue Jan 15 2002 - 15:57:21 CST