| Date: | Tue, 27 Jun 2006 13:50:15 -0700 |
|---|
| Reply-To: | Chandak <chandaknitin@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Chandak <chandaknitin@GMAIL.COM> |
|---|
| Organization: | http://groups.google.com |
|---|
| Subject: | executing pl/sql block |
|---|
|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
Is there any way to execute below oracle code in SAS?
SET SERVEROUTPUT ON
declare retval varchar2(500);
begin
retval := test;
dbms_output.put_line(retval);
end;
This function is having DDL statements also so we can't call this
function in select statement.
I want to execute user defined function and capture its output.
Thanks,
Nitin
| 
