Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DAD error

463049Nov 22 2006 — edited Dec 7 2006
Hi I'm trying to execute a procedure using a DAD on a OAS 10gR2 and a 10gR2 database when ever i call the procedure in my browser using
http://localhost:7778/mydad/Getdate.app?p_id=24506

I get the following error:

ORA-06550: line 3, column 25:
PLS-00302: component 'VC_ARR' must be declared

I thought it was the procedure I was calling so I created a much simpler one as follows:

CREATE OR REPLACE PROCEDURE TEST
AS
BEGIN
Htp.p('Hello');
END;


I called it using the same sintax as above with the same results, I'm thinking it has something to do with the OWA package, but cant seem to find a solution, any help is greatly appreciated
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2007
Added on Nov 22 2006
5 comments
624 views