Home » SQL & PL/SQL » SQL & PL/SQL » Bind variable "00" not declared.
Bind variable "00" not declared. [message #244353] Tue, 12 June 2007 07:56 Go to next message
aadhyapak
Messages: 1
Registered: June 2007
Junior Member
Insert into CIRC_PATH_INST (CIRC_PATH_INST_ID, CIRC_PATH_HUM_ID, CIRC_PATH_REV_NBR, STATUS, BANDWIDTH, TYPE, TOPOLOGY, TRUNK_
GROUP, NBR_MEMBERS, MEMBER_BW, NBR_CHANNELS, VIRTUAL_CHANS, CHAN_WARN_THRESHOLD, NBR_CHAN_ASSIGNED, NBR_ELEMENTS, CUSTOMER_ID,
A_SIDE_CUSTOMER, Z_SIDE_CUSTOMER, FRAMING, SIGNALING, ORDER_NUM, ORDERED, DUE, INSTALLED, IN_SERVICE, SCHED_DATE, DECOMMISSIO
N, PREV_PATH_INST_ID, NEXT_PATH_INST_ID, LAST_MOD_BY, LAST_MOD_TS, INST_VER, A_SIDE_SITE_ID, Z_SIDE_SITE_ID, LOCK_TS, LOCK_BY,
DESCRIPTION, ELEM_COST, DISTANCE, MAX_PCT_OVERSUBSCRIPTION, SVC_PRIORITY, TCIC_TFN_AUTOGEN, BTCIC_BTFN_NBR, TCIC_NBR_PLAN, TO
TAL_BPS_AVAIL, BPS_ASSIGNED, WARN_THRESHOLD_PCT, START_CHAN_NBR, END_CHAN_NBR, CHAN_NAME_GEN_ID, BW_ADJUST_GEN_ID, BANDWIDTH_I
NST_ID) values (CIRC_PATH_INST_ID.nextval,'LON/LON/E1P24161',5,'Ordered','2MB','DATA G703 G703','P',null,null,null,-1,null,nul
l,0,0,'REUTERS LTD / CONNECT / GLOBAL','AT&T','AMLIN PLC C/O LLOYDS OF LONDON',null,null,'0003792',2007-06-12 13:25:48.799,nul
l,null,null,2007-06-21 00:00:00.0,null,78346,null,'sshivakumar',2007-06-12 13:25:48.799,4,1075,2563,null,null,'279611 15-MAY-2
000 00:00:00 cleanse',0.0,0.0,null,null,null,null,null,2468253,0,0.0,null,null,0,0,1043)
Re: Bind variable "00" not declared. [message #244356 is a reply to message #244353] Tue, 12 June 2007 08:00 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
Format your posts if you want someone to answer. Your post looks like a jumble of letters, number and symbols. I can't read it.
Re: Bind variable "00" not declared. [message #244357 is a reply to message #244353] Tue, 12 June 2007 08:01 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
2007-06-21 00:00:00.0

Since you can't be bothered to write a normal question, I won't elaborate on the answer
Re: Bind variable "00" not declared. [message #244358 is a reply to message #244353] Tue, 12 June 2007 08:02 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Oh come on! Put at least some effort in your question! Format your code. I don't even start to read this junk.

MHE
Re: Bind variable "00" not declared. [message #244359 is a reply to message #244353] Tue, 12 June 2007 08:02 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Welcome to the forum.

Please always post your Oracle version (4 decimals).
Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS.

Break your lines at at most 80-100 nobody can read lines of 200 characters.

In your query you have: 2007-06-12 13:25:48.799.
I think this is a string, so you have to enclose it between '.
If this is a timestamp, you then have to convert it to timestamp using the appropriate function.

Regards
Michel
Previous Topic: Help with PL/SQL procedures and functions
Next Topic: Fetch & Reverse Entry
Goto Forum:
  


Current Time: Thu Dec 08 21:52:21 CST 2016

Total time taken to generate the page: 0.12264 seconds