Ask a Question related to Coldfusion Database Access, Design and Development.
-
MShaneW #1
problems executing wscript_command stored procedure
I'm trying to call the wscript_command stored procedure and use the ID of a DTS
job as one of the input parameters. I am getting the message "Error Executing
Database Query".
I know the following:
1.) The user who I am using to make the connection has dbowner access to the
database
2.) The dts package is valid and it works when I schedule it as a job just not
by calling it throught the wscript_command Stored Procedure.
3.) Bulk logged is set as the recovery mode in the database
Any ideas on what the problem/ or solution might be?
Thanks in advance for any and all ideas.
Shane
MShaneW Guest
-
Error while executing stored procedure
I get the following error message when I am trying to execute a stored procedure. It runs fine on my dev server but giving error in production. ... -
Problems with Oracle Stored Function (Procedure)
I am trying to call a function in an Oracle database package using cfstoredporc. I keep getting the following error: ORA-06502: PL/SQL: numeric... -
Executing Stored Procedure in loop duplicates row content
Hi, I am executing a stored procedure from a form post, when I execute the stored procedure it inserts a row for every checkbox checked, however... -
Executing a procedure from the cammand line
I have a SQL command procedure, myproc.sql, containing sql statements. After I login to MySQL, how do I execute this procedure? mysql> ??????... -
DBD::Oracle not executing stored procedure properly...
Hamish Whittal wrote: is this what you have in your code: "$$dbh->prepare($sql)"? david -
philh #2 Re: problems executing wscript_command stored procedure
Shane,
Where the heck is that SP? I looked high and low, in BOL, and couldn't find it.
philh Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
