Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2011
    Posts
    9

    Unanswered: Oracle Pro*COBOL pre-compiler and schema

    Is there a way of passing the schema name to the Oracle Pro*COBOL pre-compiler? This is required when config option SQLCHECK={FULL|SEMANTICS} is used to validate the tables, views and columns names against the schema.

    You can specify a USERID parameter to log on to the database but the userid I am using is not the same as the schema name I am using so it can not resolve the object names in the code as they are not prefixed with the schema name.

    Thanks,
    Mark.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    select sys_context('USERENV','SESSION_SCHEMA') from dual;
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Apr 2011
    Posts
    9
    beilstwh, that gets me the schema name back in the code or within SQL*Plus. But how do I get the Pro*COBOL compiler to receive a schema name as a parameter?

    My code sets the schema it wants at the start during run-time using
    Code:
    ALTER SESSION SET CURRENT_SCHEMA = MYSCHEMA
    but it would be really useful if the SQL pre-compiler would do its job and validate the embedded SQL fully at pre-compile time.

    Mark.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •