Hello All!

I am trying to write a procedure that will insert to a TEXT field. I can create variables using the 'references text' clause, but I have been unable to figure out how to assign a value to them. The value is dynamic and needs to be passed into the procedure as a parameter.

Any help would be appreciated.

Thanks
Laurie

IDS 11.5FC7


Laurie Gustin
IT Programmer Analyst
Department of Public Safety
lgustin (AT) utah (DOT) gov
801-965-4410

On 9/21/10 9:39 AM, Laurie Gustin wrote:
You will need to call the procedure from a host language that supports
locators - ESQL/C, possibly ODBC, JDBC, ...

You pass the locator as a parameter to the statement that executes the
stored procedure:

$ loc_t text;
...code to initialize text...
EXEC SQL EXECUTE PROCEDURE insert_text(:text);

For illustrative code that manipulates blobs in ESQL/C, see the
'vignettes' insblob, updblob, appblob, selblob, selmultiblob distributed
with SQLCMD (IIUG Software Archive: http://www.iiug.org/software).

Yours,
Jonathan Leffler