(no subject)

Please take the following example how the indicator variable can be put inside the PL/SQL block.

main()
{
EXEC SQL BEGIN DECLARE SECTION; varchar salary[20];
short ind_var;

EXEC SQL END DECLARE SECTION; EXEC SQL EXECUTE
DECLARE
     l_tab_sal varchar2(20);
 BEGIN      Here I call a pl/sql block with the paramters and out value as l_tab_sal;

    if l_tab_sal is null this is giving 1405 error . I can handle by specifying nvl but i want to handle thru indicator variables inside plsql block .

    :salary := l_tab_sal; /* HOW TO ASSIGN INDICATOR VARIABLE HERE */

END;
END EXEC; salary[salary.len] = '\0';
printf ("value is %s", salaray.arr);
}

Raman

 From: "Atish Prasad Das" <atish.das_at_wipro.com>  Date: Mon, 15 May 2000 10:07:43 +0530
Subject: Re: LONG

william,

string functions will not work with Long datatype in sqlplus stmts. u can do those operations with tables also, but in pl/sql (try the same in a pl/sql Received on Sun May 14 2000 - 22:24:19 CDT