I have an Oracle 9i forms question. I have a package called "IDEVUSA_DML_PKG." In the package I have a procedure called "RETREIVE_CLIENT_CONTACTS." I have an in out parameter called "CLIENT_CONTACTS_TYPE." The type is declared in the package "CLIENT_CONTACTS_REC." "CLIENT_CONTACTS_TYPE" is a table of "CLIENT_CONTACTS_REC." I tested this on SQL*Plus, and it compiled and executed. I then put it in the package and created a form with a data block based on the packaged procedure. In Forms I built a trigger and appended the package name, and it gave me a compilation error. I automatically generated the trigger for the procedure from the data source, and it appends the package name twice:
When I remove the appended IDEVUSA_DML_PKG, it compiles. When I run the form, forms adds IDEVUSA_DML_PKG again.
Have you specified the query data source arguments properly in the forms? Please make sure that the arguments match that of the stored procedure.