[ cf-dev ] oracle stored procedure syntax

[Osullivan Karl (RKB) Senior Analyst/Programmer]

hello I've been trying for two days to create an Oracle stored procedure (and package) for use with CF, but cannot get the syntax right.  Can anyone help...please?! I'm trying to create a procedure getTableA that will return certain fields from TableA, and another procedure getTableB to return certain fields from TableB.  I then wanted to store them in the same package as they have a similr theme.  There's no parameters to pass in. Eg. SELECT            field1, field2 FROM               tableA   I've tried the Oracle site, CF-Talk site and all sorts of others but just cannot get the syntax to work.  Any ideas anyone? Karl O'Sullivan Senior Analyst/Programmer Computer & Network Services UHCW NHS Trust Clifford Bridge Road COVENTRY CV2 2DX Contact: Tel (internal): 28952 Tel (external): +44 (0) 24 7696 8952 Email: [EMAIL PROTECTED] Web: www.uhcw.nhs.uk

<<attachment: image001.gif>>