In Oracle 9i(?), I was able to write stored procedure where I simply referenced
the field behind the parameter/variable, thus telling Oracle the type and
length implicitly (as it would look it up instead of me hardcoding it). For
example, cName as Customers.cName instead of saying cName
From: [EMAIL PROTECTED]
In Oracle 9i(?), I was able to write stored procedure where I simply
referenced the field behind the parameter/variable, thus telling Oracle the
type and length implicitly (as it would look it up instead of me hardcoding
it). For example, cName as Customers.cName
At 09:19 AM 7/21/2006 -0700, [EMAIL PROTECTED] wrote:
From: [EMAIL PROTECTED]
In Oracle 9i(?), I was able to write stored procedure where I simply
referenced the field behind the parameter/variable, thus telling Oracle
the type and length implicitly (as it would look it up instead of me
I guess you mean as in:
FUNCTION EditCust(pcCustName IN mydb.Customers.cName%TYPE, pcCode IN ...)
No, I haven't found it in ms SQL Server - it's neat and I miss it.
Andrew Davies MBCS CITP
- AndyD 8-)#
**
This email
4 matches
Mail list logo