execute stored procedure from pll
From: T.Veenstra <h.t.veenstra_at_bhf.agro.nl>
Date: 20 Sep 2001 06:53:55 -0700
Message-ID: <b65894c3.0109200553.4c391d72_at_posting.google.com>
Date: 20 Sep 2001 06:53:55 -0700
Message-ID: <b65894c3.0109200553.4c391d72_at_posting.google.com>
I want to execute a stored procedure from a pll file attached to a form. When compiling the pll file I recieve the following messsage: <proc> NOT DECLARED IN THIS SCOPE.
The stored proc is in my own schema
I have all grants
Input variabels are of the right type
Syntax is correct
Forms ver 4.5
Database ver 8.1.7
Oracle Bug??
----stored procedure ----
PROCEDURE INSERT_FORM(
I_MAO_FORM MAO_FORMN%ROWTYPE,
NAAM_PROG MAO_FORMN.NAAM_PROGRAMMA_CREATIE%TYPE
)
IS
--- call from pll -----
INSERT_FORM(I_MAO_FROMN => L_MAO_FORMN,L_NAAM_PROGRAMMA_CREATIE );
Received on Thu Sep 20 2001 - 15:53:55 CEST