mshehadeh's blog

Passing parameters to SQL PLUS from Oracle Forms


I was working on a Application using oracle forms,where i need to call a sql script file with dynamic schema (dynamic owner), so i need to pass the owner from the oracle forms,
I came with the following procedure:

Disabling constraints before the import operation


Some times you need to disable user constraints before doing the import for some user,
for this reason i created a procedure that can be used to disable the constraints before the import,and than use it again to enable the constraints after doing the import,and also this procedure can be used to drop user constraints when needed.

Subscribe to RSS - mshehadeh's blog