I'm modifying a script that connects to Oracle to collect data. Previously
it could only get data from a table, and now I'm adding ghe ability to get
data from a view.
Because of the environment it runs in, and the fact that it's configuration
table driven, on the fly. I need a LOT of error checking.
So that's where it gets interesting. Previously I was able to check for
existence of the requested table, and collumn, by checking the appropriate
Now that I'allowing views, the SQL statement can be retrived from the
"TEXT" collumn of the "ALL_VIEWS" view. However, that does not garunteee
that the sattement still points to valid table/collumn pairs.
What I have in mind is doing a prepare on this statement, and checking the
return code. Does this sound like it will catch invalis statements? If so,
how do I do this safetly without risk of causing the script to bail out on
an error?
Oravle system tables.
table tha
--
Stan Brown [EMAIL PROTECTED] 843-745-3154
Charleston SC.
--
Windows 98: n.
useless extension to a minor patch release for 32-bit extensions and
a graphical shell for a 16-bit patch to an 8-bit operating system
originally coded for a 4-bit microprocessor, written by a 2-bit
company that can't stand for 1 bit of competition.
-
(c) 2000 Stan Brown. Redistribution via the Microsoft Network is prohibited.
