Execute Pro*c

[carthyc_p]

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...

[JChiappa]

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