DAD error
463049Nov 22 2006 — edited Dec 7 2006Hi 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