Something like create or replace procedure my_proc( p_rc OUT SYS_REFCURSOR ) as begin open p_rc for select 1 col1 from dual; end; / variable rc refcursor; exec my_proc( :rc ); print rc; will work in SQL*Plus or SQL Developer. I don’t have any experience with Embarcardero Rapid XE2 so I have no idea whether it … Read more
Here is a piece of code that works. I suggest that you use explicit cursors instead of implicit ones (FOR i IN (select…)), for performance purpose. First here is the script to create testcase. create table test (c clob); insert into test (c) values ( ‘azertyuiop qsdfghjklm wxcvbn ‘); Then here is the script to … Read more
Once I wrote a general PL/SQL Package where you can do such conversions. It works for both, IPv4 and IPv6. CREATE OR REPLACE PACKAGE IP_Util AS /** * Convert an IP-Address into decimal value. * @param IP The IP-Address, e.g. ‘10.151.20.224’ or ‘1080::8:800:200C:417A’. * Supports also mixed notation like ‘0:0:0:0:0:FFFF:129.144.52.38’. CIDR value (e.g. ‘1080::8:800:200C:417A/80’) is … Read more
Write the function using plsql [closed]