Or, you could type '***' in the sql after the from statement. When you
compile, the log will give you the actual sql that the code is trying to
run, which you can copy into sql plus.
ex. begin-select
field1 &field1
field2 &field2
From TABLE ***
Where field1 = 'blah'
Just another thought to help identify the problem.
Poonam
Al H
<star111lists@mind To: sqr-users@sqrug.org
spring.com> cc:
Sent by: Subject: Re: [sqr-users]
Trying to print LONG datatypes
sqr-users-admin@sq
rug.org
03/10/2003 01:54
PM
Please respond to
sqr-users
The message you are getting is coming from Oracle, so it's related to
the SQL, not the print command. You might try running your program
with a -s parameter so you can see the actual SQL that was generated.
You can then paste it from the end of the log into SQLPlus and see
better what is happening.
On Mon, 10 Mar 2003 11:53:57 -0600, you wrote:
>I am using SQR server 4.3.4
>
>I am trying to use the print command to print a long data type field and
I
>keep getting this error
>
>ORA-00997: illegal use of LONG datatype.
>
>Is printing all or part of this field type possible. If so what do you
>suggest.
>
>Thanks for you help and time.
>
>Dave Benzenhafer
>
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users