Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL constants in packages/stored packages
I've used packages for globals in both Forms and on the database backend.
If you want to reference the package variables as globals in forms the
package needs to be defined in forms because of the different versions
of
PL/SQL as stated below. If you want to reference the variables on the
database then that's where they need to be defined.
Hope this helps a little.
Steve J.
Dave Macpherson wrote:
>
> You didn't mention what tool you were using for your front-end. Recall
> that the current Oracle Developer/2000 Forms 4.5 tool only uses PL/SQL
> V1.x, not 2.x, so perhaps it is a PL/SQL version incompatibility.
>
> This would explain why it works in SQL*Plus but not in your form.
>
> Regards,
> Dave Macpherson
Received on Thu Jul 17 1997 - 00:00:00 CDT