Category Archives: scripts for sqlplus

sql4oracle.zip updated

New files: x4o_objects – script to create the xls4oracle objects view. Joins lots of informations: SQL> desc x4o_objects  Name                                    ————————————-  OWNER                                   OBJECT_NAME                             OBJECT_DESCRIPTION                      LAST_UPDATE_DATE                        OBJECT_TYPE                             SOURCE                                  DOWNLOAD                                UPLOAD                                 load.sql – script to generate upload and download script. locks.sql – change … Continue reading

Posted in oracle applications, scripts for sqlplus, Using sqlplus | Leave a comment

sql4oracle.zip updated with new and updated files

The following scripts has been added – and lots of updates: header – show $header from database source objects ccid – show segment values for a ccid ubj – @obj on user objects cnt – count number rows in multiple … Continue reading

Posted in oracle applications, scripts for sqlplus | Leave a comment

sql4oracle.zip updated with new and updated files

The following scripts has been added/updated: @create_user – new @activate_user – new @disable_user – new @user_password – new @enable_user – new @save_profile_user – new @del_resp – updated @password – new @dump – updated @info – updated @cre_forms_pkg – new @cre_table_pkg … Continue reading

Posted in scripts for sqlplus | Leave a comment

The par.sql script updated

The par.sql script updated to use v$parameter2. This will show paramteres like control_files and utl_file_dir like this:  control_files              /u000/app/oradata/XXXX/cntrl01.dbf control_files              /u000/app/oradata/XXXX/cntrl02.dbf control_files              /u000/app/oradata/XXXX/cntrl03.dbf

Posted in oracle applications, scripts for sqlplus | Leave a comment

New script added: wf_oecogs.sql – to run oecogs workflow for a order line

This script accepts ordernumber and line and will start the oecogs workflow, showing debug messages from workflow. Great script for customizing the oecogs workflow. It is included in the sql4oracle.zip file

Posted in scripts for sqlplus | Leave a comment

New scripts for ftp of out and log from applications server to PC

The reqftp.sql will show the latest request – and you just need copy/paste the @reqft2 <request id> to download log and out files. NB: You need to edit the reqftp2.sql with your enviroment data: hostname:   def hostname = <hostname … Continue reading

Posted in scripts for sqlplus | Leave a comment

Just added: the proc scripts, to generate prototype scripts

The proc scripts will generate procedure calls with declare section, assign section and procedure call.

Posted in scripts for sqlplus | Leave a comment

Structure of Oracle Applications Database

Everything is executed with the apps user. All packages, procedures, functions and views are (or should be) owned by the apps user. Tables and indexes are owner by application users (like AR, GL, AP…) and access is granted to the … Continue reading

Posted in scripts for sqlplus, Using sqlplus | Leave a comment