Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: MurraySobol
- Content: Threads
- Order by date
-
Convert Oracle Function TO SQL Anywhere 11
I have created an Oracle Function using a reference cursor. Here is the Oracle version: CREATE OR REPLACE FUNCTION f_get_name_address_list (p_name_and_address_id IN varchar2) RETURN SYS_REFCURSOR IS v_ret SYS_REFCURSOR; BEGIN OPEN v_ret FOR SELECT...- MurraySobol
- Thread
- Replies: 7
- Forum: Oracle: All versions
-
Oracle procedure returning a table
Here is my SQL: CREATE OR REPLACE TYPE t_col AS object (name_and_address_id varchar2(26), full_name varchar2(200), parent_record_id varchar2(26), pass number ) ; / CREATE OR REPLACE TYPE id_table AS TABLE OF...- MurraySobol
- Thread
- Replies: 12
- Forum: Oracle: All versions
