| function [message #101003] |
Fri, 19 March 2004 06:13  |
alihadim
Messages: 5
Registered: March 2004
|
Junior Member |
|
|
|
hi I want to use oracle function but I'm doing functions return value one all tables values how can I do?
|
|
|
|
| Re: function [message #101014 is a reply to message #101003] |
Fri, 26 March 2004 04:08  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Hi,
You can return a record with multiple columns from a function; or simply return values using IN OUT parameters. From chapter 8 of the Oracle 9i PL/SQL Reference Guide:
"You use parameter modes to define the behavior of formal parameters. The three parameter modes, IN (the default), OUT, and IN OUT, can be used with any subprogram. However, avoid using the OUT and IN OUT modes with functions."
Best regards.
Frank
|
|
|
|
| call function and Vb platform [message #101061 is a reply to message #101014] |
Fri, 09 April 2004 23:13 |
alihadim
Messages: 5
Registered: March 2004
|
Junior Member |
|
|
hi I use ora function, I created func but I couldn't
Call on vb platform. I have made postgresqls(plpgsql)
function and I have called function it hasn't done
problem me for example:
"select * from funcname(parameter...)"
Note: I counldn't run function with sql plus
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
