| Author |
Message
|
| EricCox |
 Posted: Wed Nov 21, 2012 10:05 am Post subject: Adding New Columns to CREATE PROCEDURE shows Errors |
 |
|
Master
Joined: 08 Apr 2011
Posts: 292
|
To all,
I've added two new columns to an Oracle Stored Procedure. I've then added the two new columns to the CREATE PROCEDURE statement in the ESQL.
After I do that I get the 'Syntax error in function or procedure signature'.
How to I get the Message Flow to sync the signature with the Stored Procedure held in the database?
Thanks,
Eric |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Wed Nov 21, 2012 10:08 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Is this in toolkit? Project -> Clean All. Also don't forget that some datatypes are not intuitively mapped. Check to be sure your ESQL datatypes are mapping correctly to the Oracle datatypes.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| EricCox |
| Posted: Wed Nov 21, 2012 10:19 am Post subject: Database Connection Needed |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
Do I need to have the database connection setup on my machine the way it is on the Broker box?
I'm using Toolkit 6.1.0.3 on XP delivering a bar to MB 6.0.0.9 on Windows 2Kx.
Thanks |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Nov 21, 2012 11:18 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Nov 21, 2012 11:53 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
You only need the database defined in the toolkit if you're concerned about toolkit level warnings.
You haven't said if you're talking about warnings in Toolkit or errors in deploy or errors at runtime. |
|
| Back to top |
|
|
| EricCox |
| Posted: Wed Nov 21, 2012 12:06 pm Post subject: Missing CHARACTER |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
I had inadvertently deleted a CHARACTER declaration.
I'm good now.
Thanks |
|
| Back to top |
|
|
|
|
