|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/1/2008 6:28:59 PM
Posts: 2,
Visits: 6
|
|
Execution of a Win Demo TD (8.1) stored procedure using JDBC gives the following error-
'{' ('7B'X) is not a valid Teradata SQL token.
There is neither such token in the stored proc file nor in the table that is being used for dynamic value input.
Though I saw a similar post with the invalid token as {'OA'X) instead of '7B'X, am at wits end trying to debug this one. Any input will be highly appreciated!
Thanks,
Kabir
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/1/2008 6:28:59 PM
Posts: 2,
Visits: 6
|
|
I was accessing the TD database via JDBC and the JDBC driver was incorrect. After moving to a new version (one with this specific error corrected), the stored procedure worked just fine.
Regards,
Taher
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 4/11/2008 3:35:25 AM
Posts: 15,
Visits: 43
|
|
|
just check if one of brackets are missing eg . in ${xyz}, { or } might be missing
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 5/2/2008 2:28:55 AM
Posts: 15,
Visits: 2
|
|
|
Some times comments might contain special characters like ' or " TD Syntaxer acts little funny some times. Same sql works fine in BTEQ.
|
|
|
|