can't use oas web toolkit with 7.2 pl/sql stored procedure?
From: adi <adityabn_at_hotmail.com>
Date: 6 Aug 2001 14:04:53 -0700
Message-ID: <6875e7b9.0108061304.e62aae5_at_posting.google.com>
ignore := owa_util.tablePrint('avntdrev'); htp.bodyclose;
htp.htmlclose;
END;
/
Date: 6 Aug 2001 14:04:53 -0700
Message-ID: <6875e7b9.0108061304.e62aae5_at_posting.google.com>
I am a trying to access oracle 7.2 database from OAS 4.0.8.2 PL/SQL
application. Does anyone know how to use of web toolkit packages with
7.2 stored procedure?
Here is what I did
I wrote a simple procedure as follows
create or replace procedure alldocs
AS
ignore boolean;
BEGIN
htp.htmlopen; htp.headopen; htp.title('Documents'); htp.headclose; htp.bodyopen; htp.header(1, 'Documents');
ignore := owa_util.tablePrint('avntdrev'); htp.bodyclose;
htp.htmlclose;
END;
/
When i tried SQL>_at_alldocs.sql, I got the error for each line that contained reference to web toolkit packages(viz., htp) PLS-00201: identifier htp.htmlopen must be declared
Any suggestions?
Adi
Received on Mon Aug 06 2001 - 23:04:53 CEST