Sounds like this project is going to hell in a handcart.
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Oracle stored proc simple problem
Collapse
X
-
-
Originally posted by MarillionFan View PostSounds like this project is going to hell in a handcart.
A little knowledge is a dangerous thing as this topic clearly demonstrates.merely at clientco for the entertainmentComment
-
Leave the coding for the Bobs.Originally posted by MaryPoppinsI'd still not breastfeed a naziOriginally posted by vetranUrine is quite nourishingComment
-
This is why Oracle does my f****** nut in.
Consider the following stored procedure call :
Code:DECLARE commentTypeId integer; BEGIN Exec SP_ADD_COMMENT_TYPE ('New comment Type', commentTypeId); END;
According to the SQL Developer tools THIS IS NOT FINE.
PLS-00103: Encountered the symbol SP_ADD_COMMENT_TYPE when expecting one of the following ......
Knock first as I might be balancing my chakras.Comment
-
I haven't got a clue but have you tried it without the space:
Exec SP_ADD_COMMENT_TYPE('New comment Type', commentTypeId);“Brexit is having a wee in the middle of the room at a house party because nobody is talking to you, and then complaining about the smell.”Comment
-
Originally posted by darmstadt View PostI haven't got a clue but have you tried it without the space:
Most programming languages don't have a space between a function and parameters...Originally posted by MaryPoppinsI'd still not breastfeed a naziOriginally posted by vetranUrine is quite nourishingComment
-
Code:DECLARE commentTypeId integer; IS BEGIN Exec SP_ADD_COMMENT_TYPE ('New comment Type', commentTypeId); END;
merely at clientco for the entertainmentComment
-
Oracle is rusty, but don't you need a colon in front of the variable?
And it's not got a value - what's it trying to do?Comment
-
-
Originally posted by suityou01 View PostThis is why Oracle does my f****** nut in.
Consider the following stored procedure call :
Code:DECLARE commentTypeId integer; BEGIN Exec SP_ADD_COMMENT_TYPE ('New comment Type', commentTypeId); END;
According to the SQL Developer tools THIS IS NOT FINE.
I have tried it with and without EXEC. I have tried it with and without CALL. I have tried it in SQL+.
Code:DECLARE commentTypeId integer; BEGIN SP_ADD_COMMENT_TYPE ('New comment Type', commentTypeId); END;
You're using SQL Developer so when you look at the SP in the procedures 'folder' is there a 'x' next to the SP?McCoy: "Medical men are trained in logic."
Spock: "Trained? Judging from you, I would have guessed it was trial and error."Comment
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Comment