help: pass the parameter to the pl/sql

From: Mike F <u518615722_at_spawnkill.ip-mobilphone.net>
Date: Tue, 15 Jan 2002 20:10:04 GMT
Message-ID: <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 - 14:10:04 CST