kinterbase and stored procedure

Alexander Eisenhuth newsuser at stacom-software.de
Tue Oct 12 09:45:17 CEST 2004


Gandalf schrieb:
> 
>> 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) 
> 
> 
> Yes, that is true. The "SET TERM" command is not really a command that 
> is processed by the backend.
> Please note that the terminator is used to separate commands. However, 
> you will (normally) execute only one
> command at a time with "cursor.execute". So you should create your 
> procedure without the "SET TERM".
> InterBase will surely know that this is only one command. You can try to 
> run the "SET TERM" command
> in a separate "cursor.execute", but probably that is not needed. I had 
> the same problem with Oracle triggers
> before - you must not place the ending "/" character when createing 
> Oracle triggers from your own program.
> 
> Please let me know if it helps.
>

Thanks a lot, that is the solution.



More information about the Python-list mailing list