kinterbase and stored procedure
newsuser at stacom-software.de
Mon Oct 11 16:10:04 CEST 2004
Hallo everybody using kinterbase,
I' relative new to DB and python, so forgive if the
questions is stupide.
I'm trying to write the declaration of a SP to the server in
SPSETUP = \
"SET TERM !!;
" CREATE PROCEDURE MYPROC
cursor = kinterbasdb.connect(...)
But it seems that anything has problems with "SET TERM !!"
expression . If I use the DB SQL console, everything seems
to be OK (the proc is setup)
''' kinterbasdb.ProgrammingError : (-104,
'isc_dsql_execute_immediate: Dynamic SQL Error. SQL error
code = -104. Token unknown - line 1, char 4. TERM. ') '''
Any help is very welcome ...
More information about the Python-list