Hi,
I finally tracked down the problem.
The following query causes the problem.
INSERT INTO SUBSCRIBER ( SUBSCRIBER_NO, SUBSCRIBER_ID, FIRST_NAME, LAST_NAME,
NICK_NAME, EMAIL_ID, SEX, DATE_OF_BIRTH, MARITAL_STATUS, MOBILE_PHONE_NO,
WORK_PHONE_NO, HOME_PHONE_NO, ADDR_LINE1, ADDR_LINE2, LATITUDE, LONGITUDE,
VOICE_PRINT_KEY, PIN, LANGUAGE, BLOCK_ACCESS, AUTO_PROVISIONED, ACCESS_START_DATE,
ACCESS_END_DATE, SERVICE_GROUP_NO, WAP_ID, VOICE_ID, PREFERRED_DELIVERY_MODE,
BLOCK_PERSONAL_INFO, DEVICE_TYPE, WAP_BROWSER, AUTH_METHOD_TYPE, HINT_QUESTION,
HINT_ANSWER, TIME_ZONE ) VALUES (36, '9198450045', NULL, NULL, NULL, NULL, NULL, NULL,
NULL, '91-98450045', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'en_IN', 0, 1,
TO_Date( '11/18/2002 12:19:24 PM', 'MM/DD/YYYY HH:MI:SS AM'), TO_Date( '01/01/2037
12:00:00 AM', 'MM/DD/YYYY HH:MI:SS AM'), 2, NULL, NULL,NULL, NULL, NULL, NULL, NULL,
NULL, NULL, 'Africa/Timbuktu')
The problem is caused by TO_Date( '11/18/2002 12:19:24 PM', 'MM/DD/YYYY HH:MI:SS
AM'),so SAPDB does'nt like times after 12:00:00 PM why? What options to i have ? can i
change the date mode? How do i fix this?
Note: QUERY is run in SQLMODE ORACLE
SAPDB 7.3.0.25
Thanks and hoping for a quick reply,
regards,
Ajit
P.S:tried the web sql,there select * from subscriber does'nt work at all same -9999
error.
-----Original Message-----
From: ajit_cus
Sent: Friday, January 03, 2003 9:05 AM
To: '[EMAIL PROTECTED]'
Subject: Re:SQLStudio -9999 error
Hi,
This is extremely error URGENT.
What does a -9999 general error with no underlying exception in SQLStudio mean?
regards,
Ajit
>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<
From: ajit_cus
Sent: Thursday, January 02, 2003 9:43 AM
To: '[EMAIL PROTECTED]'
Subject: SQLStudio -9999 error
Hi,
I am using SAPDB 7.3.0.25 with SQLmode ORACLE.
I have a table called SUBSCRIBER.
When i right click on the subscriber table in catalog view and select show content,i
get an error -9999 [SQLOD32.dll].However on opening an SQL window, select * from
SUBSCRIBER and all other queries on the table work fine.
What causes the problem with SQLStudio and how can i fix it?
regards,
Ajit
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
