help! – - – trigger compilation error when calling a stored procedure.

pts.
Tags:
Oracle development
my trigger wont compile. below is the code and errors. Any help is greatly welcomed. thanks very much. DECLARE ROWCNT NUMBER; PIN NUMBER; SIGNUP_URL VARCHAR; -- -- BEGIN SIGNUP_URL := 'http://signup.2gn.com/signup.pl'; SELECT COUNT(*) INTO ROWCNT FROM SUBSSHORTCODE WHERE SHORT_CODE = :N.SHORT_CODE AND SUBSCRIBER_PHONE= :N.SUBSCRIBER_PHONE; IF rowcnt >0 THEN UPDATE MSGLOG SET STATUS = 'A' WHERE MESSAGE_ID = :N.MESSAGE_ID; -- Send the auth notification to the -- content provider. CALL SEND_MESSAGE(N.SUBSCRIBER_PHONE, N.SHORT_CODE, 'mcinc', ;; mcinc is a sample content provider smsc 'AUTH') ELSE -- pin_number needs to be an integer in the sub pin table PIN := ROUND ( DBMS_RANDOM.VALUE(1000,9999), 0); INSERT INTO SUBSCRIBER_PIN (SUBSCRIBER_PHONE, PIN_NUMBER) VALUES (:N.SUBSCRIBER_PHONE, PIN); CALL SEND_MESSAGE(N.SUBSCRIBER_PHONE, N.SHORT_CODE, 'nokia', ;; send pin directly to the subscriber 'Sign up for this program at ' || SIGNUP_URL || ' with pin number ' || PIN); END IF; END; **** errors are below ********* LINE/COL ERROR -------- ----------------------------------------------------------------- 19/9 PLS-00103: Encountered the symbol "SEND_MESSAGE" when expecting one of the following: := . ( @ % ; The symbol ":=" was substituted for "SEND_MESSAGE" to continue. 21/35 PLS-00103: Encountered the symbol ";" when expecting one of the following: ( - + case mod new not null others <an identifier> <a double-quoted delimited-identifier> <a bind variable> avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification> <a number> <a single-quoted SQL string> pipe <an alternatively-quoted string literal with character set specification> <an alternatively-q SQL> --

Answer Wiki

Thanks. We'll let you know when a new response is added.

Just remive the CALL keyword and add a semi-colon to this instruction.

SEND_MESSAGE(N.SUBSCRIBER_PHONE,
N.SHORT_CODE,
‘mcinc’, ;; mcinc is a sample content provider smsc
‘AUTH’);

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ceepari
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/help-trigger-compilation-error-when-calling-a-st... (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following