PL/SQL (MOSC)

MOSC Banner

return concatenation string with procedure

edited Sep 13, 2013 1:47AM in PL/SQL (MOSC) 5 commentsAnswered ✓
Hello,

I created one procedure and i want to return concatenation string out parameter in procedure. below is the code. 


 create or replace procedure GET_REPORTED_BASELINE_COUNT (device_type_id IN number, baseline_id IN number, result_str out varchar2)
AS
stringtext            varchar2(1000);
stringtext1            varchar2(1000);
v_device_type_id      number(20);
v_baseline_id         number(20);
v_code                varchar2(30);
result                number;
result_str            varchar2(30);
cursor c_code is select distinct EC_SERVER_SECURITY_CODE from customer_info;
BEGIN
     open c_code;
     v_device_type_id := device_type_id;
     v_baseline_id := baseline_id;
     loop
          fetch c_code into v_code;
           exit when c_code%NOTFOUND;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center