You'll need quotes around the values as well:
INSERT INTO [EMAIL PROTECTED] (SENDER, MOBILENO, MESSAGE) values
("Remedy", "$Mobile Number$", "$Message$")
Regards,
Michiel
On 5/8/06, Rami S Ayoub <[EMAIL PROTECTED]> wrote:
**
Dear list
I'm using INSERT INTO to integrate with SMS Manager one of oracle module ,
When trying to but the values to push date on the SMS , give me Error
ORA-(Columns not allowed here)
When I remove those two field $Mobile Number$ , $Message$ its work .
INSERT INTO [EMAIL PROTECTED] (SENDER, MOBILENO, MESSAGE) values
("Remedy", $Mobile Number$, $Message$)
Any one has any information regarding this issue?
Best regards
Rami S Ayoub
__20060125_______________________This posting was
submitted with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
