Hi Jeff,

Its not a syntax problem it's the way the work. You can pass either a
session table or normal parameters, not both.

Peter

T: +44 (0)1398 341777
PGale@Comp-Soln.co.uk

-----Original Message-----
From: info-ingres-admin@cariboulake.com
[mailto:info-ingres-admin@cariboulake.com] On Behalf Of
jeffrey.duffy@gro-scotland.gsi.gov.uk
Sent: 26 August 2005 09:14
To: info-ingres@cariboulake.com
Subject: [Info-ingres] Help with DB Procedure syntax

Hoping someone can help?

I am trying to pass a global temporary table AND several variables to a
DB Procedure. I can happily pass a table on its own and as many
variables as I like on their own but NOT together. Im sure this is just
a syntax problem. Has anyone come accross this and help with the syntax
??

Thanks guys

Jeff

_______________________________________________
Info-ingres mailing list
Info-ingres@cariboulake.com
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres