>my partner here that they're >insecure so off-limits.
>
>FWIW, SQL Plus is hardly a gui. It's the standard Oracle client tool.
Sorry, since I don't have access to any Oracle tools, I didn't know that. I just assumed it was GUI based to make things easier. I'll check to see if there's a subset of tools that I'm allowed to use.
>>Nonetheless, I got the command to make the trigger work using your original
>code, which was easy once >I realized there was no 'user'. It told me that
>it executed. I did:
>
>What's "it" in the "It told me that it executed." statement?
Sorry again for the pronoun. I have a form and I put the trigger code into a text field and do a SUBMIT. That just puts it in:
<CFQUERY NAME="ORACLE_EXE" DATASOURCE="dpxh">
#oracle_statement#
</CFQUERY>
which then responded with "statement executed", which means that no errors were generated.
>The error
>you're recieving means that the trigger has not been compiled correctly.
>It's compiled, but invalid. Whatever tool you're using should be able to
>tell you that.
yeah, no tools. Sorry to sound like a complete dunce. I feel like one.
>You should also be able to run this query:
>select * from user_triggers
>From a CF query?
>It will show you the name of any triggers you have access to and their
>status.
>If you're not going to use the for update part, I'd go with Jochem's
>simplified version of the trigger.
ok, thanks.
>>I just figured that >the trigger would toss it. True? The
>Yes, it should ignore the passed in value. But, you should alter your code
>so as to not pass in a value.
ok. It was just a place-holder. I shouldn't need to include it at all really, right?
>However, if you want to make your life much much easier, and you know that
>CF is the only user writing to this table, you can just use this syntax and
>drop the trigger entirely. (This has the same effect of adding the next
>number in the sequence, but only affects this particular query.)
well, I happen to know that it's the only way to access the table right now and expect that to be the case in the future, but really no one knows...
Beyond that, I'd like to understand why the trigger didn't work to learn more - though I've learned quite a bit up to this point. Plus we've all invested so much time in getting me there that I'd like to hop over the finish line :)
>(Side note: You should get in the habit of using cfqueryparams.)
You mean for performance? I just glanced over it. It looks like it's quite a bit of information and needs more than a glance.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
