Re: DBMS_SQL & Forms 4.5 ?

From: Steve Cosner <stevec_at_zimmer.CSUFresno.EDU>
Date: 1996/09/10
Message-ID: <514him$hj6_at_zimmer.CSUFresno.EDU>#1/1


In article <3235EA33.68E8_at_pz-oekosys.uni-kiel.d400.de>, Friedel Hosenfeld <friedel_at_pz-oekosys.uni-kiel.d400.de> wrote:
>I tried to make a procedure in Forms (4.5.6.0.7, RDBMS: 7.1.4.3.2)
>with some calls of DBMS_SQL. But the Forms Designer tells
>me that it doesn't know "DBMS_SQL".
>With SQL*Plus the same procedure compiles fine!

I have used dbms_sql from a form, but several of the calls will not compile: dbms_sql.parse and dbms_sql.column_value. I got around the problem by creating stored procedures to call each of these, and calling the stored procedures from the form. This worked fine.

(For those who want to know, documentation on dbms_sql is in the Oracle 7 Server Documentation Addendum)

Steve Cosner   Received on Tue Sep 10 1996 - 00:00:00 CEST

Original text of this message