Autonumber difficulties?

We have successfully implemented an autonumber for a form but are experiencing difficulty inserting the record into the database. On this page we insert a new contact person, but we run into the following error and no data posted to our database:

"ORA-06550: line 2, column 16:PL/SQL: ORA-00947: not enough values
ORA-06550: line 2, column 4: PL/SQL: SQL Statement ignored"

The "not enough values" part makes me think there's a problem with passing the parameter, but I'm not sure where or how. I've checked the ordering in the SQL statement and it appears fine. I'm guessing the problem is somewhere on the XML side. Has anyone else experienced something similar to this? What steps did you have to take in order for your parameters to pass through properly as queries?

Comments

[Daniel Adams]

Tom, we're going to Qdoba tonight. make the necessary adjustments.

Grizz

[Charley]

Tom,

Are you using an array? If so, be sure there aren't too many brackets:

INSERT INTO Test_Tom VALUES Test_Array(i);

Here's a seperate example I found on expertsexchange

create table temp_clob(a clob);

set serveroutput on format wrapped size 8000
declare
queryCtx DBMS_XMLquery.ctxType;
result CLOB;
begin
-- set up the query context...!
queryCtx := DBMS_XMLQuery.newContext('select * from tb_vehicle where engine_size between :minsize and :maxsize');
-- set the bind variables
DBMS_XMLQuery.setBindValue(queryCtx,'minsize',1100);
DBMS_XMLQuery.setBindValue(queryCtx,'maxsize',1900);
-- change the tag names
DBMS_XMLQuery.setRowTag(queryCtx,'VEHICLE_RECORD'); -- sets the row tag name
DBMS_XMLQuery.setRowSetTag(queryCtx,'VEHICLE_ROWSET'); -- sets rowset tag name
-- get the result..!
result := DBMS_XMLQuery.getXML(queryCtx);
-- Now you can use the result to put it in tables/send as messages..
-- print xml out to screen
printClobOut(result);
-- store xml as a clob
delete from temp_clob;
insert into temp_clob values (result);
commit;
-- close query handle
DBMS_XMLQuery.closeContext(queryCtx);
end;

-Charley

[axiobia]

Good aftenoon !

[Kolt]

test, specal olympics in michigan, 55170, longe lingerie, 04932, adult bible stories about walking on water, 581488, splymouth college, 83525, logitech webcam, xki, adult catalog by mail, ufnh, pictures of the mouth, 0574, laoh in massachusetts, 88932,

[Anzeigen69]

Wem soll ich wu"nschen Frohe Ostern?

Allen eigentlich die diesem Forum lesen und schreiben Vielleicht Auch.

Na gut, es gibt ein Paar Vielleicht Ausnahme.

Pelzlose Dauergru"nhinterdenohrenhasen, die schnell Feierabend gemacht haben, weil sie sich selbst ertragen nicht mehr und leben wohl jetzt konnten in der Grube.

Wie immer ... AUCH

Hort auf, das zu Ostern oder den Hunden und Katzen Osterhasenohrenprothesen kommerzialisieren anzukleben.

Geliebte und der Nachbar Hobbyja"ger Schiesser drauf sonst ko"nnte.

So schreibt hier im Forum und ab und zu was wrong.

Das ist keine Internet www.adseu.net

[arenseWopecappo]

I would like to thank You for being the member of this website. Please allow me to have the chance to express my satisfaction with HostGator web hosting. They have professional and quick support and they also offer many Host gator coupons.

I appreciate Hostgator hosting, You will too.

The official Twitter account of HostGator.com, a leading provider of web hosting, reseller hosting, VPS HostGator Web Hosting - $3.96/month | HostGator Reviews

HostGator Web Hosting Information Resource Site. Get the latest updates on Hostgator Web Hosting.
Hostgator Review - Do They Live Up To The Hype?

Our Hostgator review dives deep into their service. In this review you will learn exactly what you will get if you decide to use them as a hosting provider.

HostGator India is a leading provider of web hosting, reseller hosting, vps hosting , and dedicated servers. Over 5000000 websites trust HostGator for their web ...

HostGator is a Houston-based web hosting company with an additional presence in Austin, Texas. It was founded in 2002 by Brent Oxley, who was then a HostGator Review - 35 Customer Reviews of HostGator

HostGator Reviews: 3.19 out of 5, based on 35 customer reviews of HostGator. Check our HostGator reviews and ratings before signing up with HostGator.

I need dedicated servers for downloading | HostGator Coupons Code

hi i want to upload many big files & share them with direct links & many people will download them so i want unlimetid traffic also i want them to.

Hostgator Coupon With Free Link Building Campaign.

Use our Hostgator Coupon site and get Free SEO, Free Link Building and Free Website Traffic. Forget the rest! Hostgator coupon code 2011, hostgator coupon code 2012

[arenseWopecapuo]

Thank You for being the member of this website. Please allow me to have the chance to express my satisfaction with Host Gator web hosting. They have professional and instant support and they also offering numerous HostGator coupons.

I like hostgator hosting, You will too.

The official Twitter account of HostGator.com, a leading provider of web hosting, reseller hosting, VPS HostGator Web Hosting - $3.96/month | HostGator Reviews

HostGator Web Hosting Information Resource Site. Get the latest updates on Hostgator Web Hosting.
Hostgator Review - Do They Live Up To The Hype?

Our Hostgator review dives deep into their service. In this review you will learn exactly what you will get if you decide to use them as a hosting provider.

HostGator India is a leading provider of web hosting, reseller hosting, vps hosting , and dedicated servers. Over 5000000 websites trust HostGator for their web ...

HostGator is a Houston-based web hosting company with an additional presence in Austin, Texas. It was founded in 2002 by Brent Oxley, who was then a HostGator Review - 35 Customer Reviews of HostGator

HostGator Reviews: 3.19 out of 5, based on 35 customer reviews of HostGator. Check our HostGator reviews and ratings before signing up with HostGator.

I need dedicated servers for downloading | HostGator Coupons Code

hi i want to upload many big files & share them with direct links & many people will download them so i want unlimetid traffic also i want them to.

Hostgator Coupon With Free Link Building Campaign.

Use our Hostgator Coupon site and get Free SEO, Free Link Building and Free Website Traffic. Forget the rest! Hostgator coupon code 2011, hostgator coupon code 2012