Title: Passing arrays
How do you get an array of elements to be passed to a stored proc such that you can use the array in a SELECT statement in the WHERE clause
- e.g. WHERE field IN (array) etc...
CREATE OR REPLACE FUNCTION sp_report_retail_sales(int8[]) RETURNS SETOF sp_report_retail_
Title: "function has no parameter $1" - help.
I'm trying to create a trigger to enforce a constraint onto two possible foreign tables
my function is defined as:
<-- snip -->
CREATE OR REPLACE FUNCTION sp_check_tranitem_productid(tbl_tranitem.fld_tranitem_id%TYPE,
Title: FW: [SQL] Converting clarion
-Original Message-
From: Michael Weaver
Sent: Friday, 31 January 2003 10:16 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [SQL] Converting clarion
If you have access to the Clarion database tools then it's really a pretty trivial
Title: Default Permissions (repost from Novice)
How can I set default permissions on tables, so that I don't have to manually set them for every table?
p.s.
This is a re-post from the novice list, I thought it might also be appropriate to ask here.
MIKE WEAVER
Software Developer
5, 42 Lad
