Hello Perl Gurus,
I have a perl script that does the following kind of a query:
insert into MY_TABLE (LABEL_ID, MY_NAME, MY_ADDRESS, XML_TEXT)
select 2, MY_NAME, MY_ADDRESS, XML_TEXT from MY_TABLE where label_id=1;
The desciption of the table is as follows:
LABEL_ID NOT NULL NUMBER(38)
MY_NAME NOT NULL VARCHAR(32)
MY_ADDRESS VARCHAR(252)
XML_TEXT LONG
When I run this query, it returns an error saying ORA-0997 Illegal use
of LONG datatype
Is there a way I can run a query that does the same? Please note that
LABEL_ID is something
that I pass in the Perl script, so it is to some extent dynamic query (I
have prepare statement that
has something like $label_id).
The only thing I can think of is writing a PL-SQL/Stored Procedure for
this. However, again,
I don't know how the PL-SQL will look like for this kind of query where I
can pass in the label_id
as a parameter.
You help is highly appreciated.
Thanks.
NRK
