Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ml_add_table_script not preserving case

2 views
Skip to first unread message

rtoellner

unread,
Nov 11, 2010, 1:01:38 PM11/11/10
to
Got an issue running the ml_add_table_script procedure on an Oracle
DB. When I execute:

exec ml_add_table_script( 'version', 'UPPER_TABLE', 'download_cursor',
'select columns from tables where x = ' 'UPPER VALUE' ' )

it actually adds the table 'upper_table' to the ml_table table and
then in the ml_script table the query will have 'upper value'

Ideas? I've run this procedure before with no problems in the past.
Just noticed this when I was trying to update a script

I am running this script within TOAD if that may make a diff.

0 new messages