Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> parsing sql-statements

parsing sql-statements

From: Jan Smit <jansmit_at_microsoft.com>
Date: Mon, 26 Jul 1999 13:20:54 +0200
Message-ID: <7nhgbf$7q8$1@news1.xs4all.nl>


Hi!

I'm using Oracle 8.0.5 and I'm trying to add things to a table using Visual Basic 5.
Turns out that SQL-statemants are parsed to about 700 characters. Is there a way to increase this number, or an easy work-around?

I'd be VERY greatful for an answer!!

The command I'm trying to send is:

INSERT INTO PATENT
(PN,PNTYPE,PNDATE,AN,ANDATE,ET,FT,DS,PR,MC,IC,PA,INV,VERWERKT) VALUES ('WO 1234567 A1','WO', TO_DATE('01-01-1998','DD-MM-YYYY'),'US 1234567', TO_DATE('01-01-1998','DD-MM-YYYY'),'CONDUCTIVE POLYMER COMPOSITIONS, ELECTRICAL DEVICES AND METHODS OF MAKING','COMPOSITIONS POLYMERES CONDUCTRICES, DISPOSITIFS ELECTRIQUES ET PROCEDES DE ATION','AL AM AT AU AZ BA BB BG BR BY CA CH CN CZ DE DK EE ES FI GB GE GH HU IL IS JP KE KG LC LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM UA UG UZ VN YU ZW GH GM KE LS MW SD SZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD ','US 8/986,889 971208','H01B- 01/20','H01B- 01:22, H01B- 01:24, H01C- 07:02, C08K- 03:04, C08K- 03:08','CBS CORPORATION','SADHIR, Rajender, K.; SAUNDERS, Howard, E.; SCHOCH, Karl, F., Jr.; SMITH, James, D., B.','N'); Received on Mon Jul 26 1999 - 06:20:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US