> Just to note, I asked the University myself (instead of relying on the
info from others) if there are any tools that we can use to work with the
Oracle DBs and I was told that "there's nothing that you can't do with a CF
entry that you can with those tools. It's more secure with a shared hosting
environment to just allow CF."
Yeesh. That's very very unfortunate. Perhaps you should pester your DBA's to
write the trigger for you, then. ;) And, as for security, I hardly think
it's more secure to give CF complete free rein with your database (which it
must have if you can create triggers and stored procs and everything through
CF). It would be much more safe to give CF only _execute_ access to stored
procs, and give you a direct account (different from the cf account) to do
your development.
Regardless, you'll probably want to get cozy with the data dictionary, then.
You'll be able to glean a lot of information about the objects in the
database by using the data dictionary (as long as the CF account has select
access to those tables). (Google: oracle data dictionary) to learn more.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
