kinterbase and stored procedure

Alexander Eisenhuth 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 
the way:

SPSETUP = \
"SET TERM !!;
" CREATE PROCEDURE MYPROC
   AS ..."

cursor = kinterbasdb.connect(...)
cursor.excute(SPSETUP)

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

Regards
Alexander



More information about the Python-list mailing list