Execute Pro*c
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Execute Pro*c

  1. #1
    Join Date
    Aug 2005
    Posts
    5

    Execute Pro*c

    Hi All,

    When I execute a procedure from VC++ program, I get an error,

    "EXEC ORACLE OPTION (SQLCHECK=SEMANTICS);
    and
    SQLCHECK value exceeds command line value "

    Can any body tell me how to come out of it.

    Thanks in advance...

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    Sorry, but I´m not with you here : in the good book (ie, "Pro*C/C++ Precompiler Programmer's Guide" manual) it gives the following example to call a procedure :

    .....

    To call a stored subprogram from your host program, you can use either an anonymous PL/SQL block, or the CALL embedded SQL statement.

    Anonymous PL/SQL Block
    In the following example, you call a standalone procedure named raise_salary:

    EXEC SQL EXECUTE
    BEGIN
    raise_salary(:emp_id, :increase);
    END;
    END-EXEC;

    ....

    I ** truly ** do not understand your :

    "EXEC ORACLE OPTION (SQLCHECK=SEMANTICS);"

    the SQLCHECK is a pro*c parameters, it normally is defined in the parameter file, OUTSIDE the program :

    Pro*C/C++: Release 9.2.0.5.0 - Production on Qua Ago 10 13:42:56 2005

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Valores default de opção do sistema obtidos de: /u1/app/oracle/product/9.2.0/precomp/admin/pcscfg.cfg

    Nome da opção Valor Atual Descrição
    -------------------------------------------------------------------------------
    auto_connect não Allow automatic connection to ops$ account
    char_map charz Mapping of character arrays and strings
    close_on_commitnão Close all cursors on COMMIT
    cmax 100 CMAX Value for connection pool
    cmin 2 CMIN Value for connection pool
    cincr 1 CINCR Value for connection pool
    ctimeout 0 CTIMEOUT Value for connection pool
    cnowait 0 CNOWAIT Value for connection pool
    code kr_c The type of code to be generated
    comp_charset multi_byte The character set type the C compiler supports
    config default Override system configuration file with another
    cpool não Support connection pooling
    cpp_suffix *nenhum* Override the default C++ filename suffix
    dbms native v6/v7/v8 compatibility mode
    def_sqlcode não Generate '#define SQLCODE sqlca.sqlcode' macro
    define ORASTDARG Define a preprocessor symbol
    *nenhum*
    duration transaction Set pin duration for objects in the cache
    dynamic oracle Specify Oracle or ANSI Dynamic SQL Semantics
    errors sim Whether error messages are sent to the terminal
    errtype *nenhum* Name of the list file for intype file errors
    fips none FIPS flagging of ANSI noncompliant usage
    header *nenhum* Specify file extension for Precompiled Headers
    hold_cursor sim Control holding of cursors in the cursor cache
    iname *nenhum* The name of the input file
    include *nenhum* Directory paths for included files
    intype *nenhum* The name of the input file for type information
    lines não Add #line directives to the generated code
    lname *nenhum* Override default list file name
    ltype short The amount of data generated in the list file
    maxliteral 1024 Maximum length of a generated string literal
    maxopencursors 100 Maximum number of cached open cursors
    mode oracle Code conformance to Oracle or ANSI rules
    nls_char *nenhum* Specify National Language character variables
    nls_local não Control how NLS character semantics are done
    objects sim Support object types
    oname *nenhum* The name of the output file
    oraca não Control the use of the ORACA
    pagelen 80 The page length of the list file
    parse full Control which non-SQL code is parsed
    prefetch 100 Number of rows pre-fetched at cursor OPEN time
    release_cursor não Control release of cursors from cursor cache
    select_error sim Control flagging of select errors
    sqlcheck syntax Amount of compile-time SQL checking
    sys_include /usr/include Directory where system header files are found
    threads não Indicates a multi-threaded application
    type_code oracle Use Oracle or ANSI type codes for Dynamic SQL
    unsafe_null não Allow a NULL fetch without indicator variable
    userid *nenhum* A username/password [@dbname] connect string
    utf16_charset nchar_charset The character set form used by UTF16 variables
    varchar não Allow the use of implicit varchar structures
    version recent Which version of an object is to be returned


    or you can put it in the pro*c options manually before the precompilation, I really do not know why you are tryng to do it INSIDE the program with EXEC command...

    Regards,

    Chiappa

Posting Permissions

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



Click Here to Expand Forum to Full Width