Link to home
Start Free TrialLog in
Avatar of sun_ora_hpt
sun_ora_hpt

asked on

oracle d2k - save forms,pl/sql in database

can any one tell me how to save oracle d2k forms, pl/sql libraries
into the database. Thanking u in advance.
Avatar of Helena Marková
Helena Marková
Flag of Slovakia image

I think that it is better to save form module in a file.

You can use the Access preference (ToolsPreferences Access tab) to change your Preferences file.

In the Module Access option, you can specify one of the following storage preferences for opening and saving modules:

File     Modules are loaded from and saved to the file system.
Database     Modules are loaded from and saved to the database.
Ask     Modules can be loaded from and saved to either the file system or the database.  Form Builder will prompt for the location of the file each time you perform these operations.

Module:  All

Default FILE

Henka
Avatar of sun_ora_hpt
sun_ora_hpt

ASKER

Thanks, Henka. I tried this way, I think this will get saved, but the problem is that it is giving error

PDE-PLI031  unable to fetch record from table TOOL_MODULE.

 I think to build the related tables, i tried to run the
develoer 2000 R2.0 admin / develoer 2000 build option,
It asks system passwd, Then it asks

 Enter Database Connection (e.g t:node:sid)[local] :

please tell me what parameter should i provide in the above ie t,node etc,
Thanking u in advance.
ASKER CERTIFIED SOLUTION
Avatar of Helena Marková
Helena Marková
Flag of Slovakia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, it worked out.