Home » Developer & Programmer » Application Express & MOD_PLSQL » apex (apex)
apex [message #585420] Sat, 25 May 2013 03:25 Go to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
I have created a form and interactive report with a table , cargo .

However , when I enter data in forms and click save , the data is not inserted in the table , cargo.

Pls help , and let me know the solution
Re: apex [message #585432 is a reply to message #585420] Sat, 25 May 2013 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 59196
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How many topics titled "apex" will post in the "apex" forum?
Don't you think the title is quite silly?

Please read OraFAQ Forum Guide.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: apex [message #585443 is a reply to message #585432] Sat, 25 May 2013 11:35 Go to previous messageGo to next message
Littlefoot
Messages: 19636
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I think I already told you so, but - here you are, again: it is close to impossible to fail in what you are unsuccessfully trying to do for months now. Apex Wizard will create an Interactive Report for you, switch to a Form creation and - within several simple <Next> ... <Next> steps - you'll have a working report & accompanying form. Yes, both of these will most probably be as ugly as a tax collector, but they WILL WORK. Once you do that, make them fancy.

I really wouldn't know what you did wrong ... as I said, it is nearly impossible to do what you managed to do.
error ora-44003 [message #585471 is a reply to message #585443] Sun, 26 May 2013 02:47 Go to previous messageGo to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
When I try to insert from forms I get the following error .

ORA-44003: invalid SQL name

Unable to process row of table CARGO.








0.54600 0.50000 ...Process "Fetch Row from CARGO": DML_FETCH_ROW (AFTER_HEADER) F|#OWNER#:CARGO:P2_FEDID:FEDID
Re: error ora-44003 [message #585508 is a reply to message #585471] Mon, 27 May 2013 02:36 Go to previous messageGo to next message
Littlefoot
Messages: 19636
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what Oracle says:
Quote:

ORA-44003: invalid SQL name

Cause: The input parameter string was not a valid simple SQL name.

Action: Check with the DBMS_ASSERT spec to verify that the parameter string is a valid simple SQL name.

Unfortunately, I wouldn't know what it means and how to fix it.

Reading your messages, I thought that maybe you should start writing a blog, such as this one - Annals of Oracle's Improbable Errors. I'm amazed with every new message you post, reporting things I've never even seen before. Truly amazing.
Re: error ora-44003 [message #585511 is a reply to message #585508] Mon, 27 May 2013 03:03 Go to previous messageGo to next message
John Watson
Messages: 4591
Registered: January 2010
Location: Global Village
Senior Member
The "ORA-44003: invalid SQL name" return code can actually be a useful return code. I've seen it used, with dbms_assert, to detect attempts to hack web applications by sending URLs that include strings that might be appended to dynamic SQL statement. Like this, where I test whether a value is a legitimate object name (though not whether it exists) or not:
orcl>
orcl> select dbms_assert.simple_sql_name('emp') from dual;

DBMS_ASSERT.SIMPLE_SQL_NAME('EMP')
---------------------------------------------------------------------------------
emp

orcl> select dbms_assert.simple_sql_name('emp and nasty_function=0') from dual;
select dbms_assert.simple_sql_name('emp and nasty_function=0') from dual
       *
ERROR at line 1:
ORA-44003: invalid SQL name
ORA-06512: at "SYS.DBMS_ASSERT", line 160


orcl>

I think the idea is that programmers should always test every parameter to make sure it is what they expect. Almost certainly, there is something in OP's form that refers to an impossible table name: one with spaces or some such.
Re: error ora-44003 [message #585512 is a reply to message #585511] Mon, 27 May 2013 03:12 Go to previous messageGo to next message
Littlefoot
Messages: 19636
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you, John! Much clearer now!
error ora-44003 [message #585517 is a reply to message #585511] Mon, 27 May 2013 03:29 Go to previous messageGo to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
I am working with apex .

I had a base table with a primary key , fedid . Then I created a forms and interactive report . It was working fine , ie when I enter data , it was inserting in the table .

I made the fedid column to hidden , the again changed it to primary key , this is when I get the 0ra-44003 error .

how do i solve this problem, thanks
Re: error ora-44003 [message #585518 is a reply to message #585517] Mon, 27 May 2013 03:54 Go to previous messageGo to next message
Littlefoot
Messages: 19636
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
I made the fedid column to hidden

As far as I can tell, that does NOT affect form's execution (not in a way you described).

Quote:
the again changed it to primary key

Where and how did you do that? Why did you do that? It already was a primary key column, wasn't it? HIDDEN attribute doesn't change that.

Did you, by any chance, delete that item, and then tried to recreate it manually?

[Updated on: Mon, 27 May 2013 03:54]

Report message to a moderator

Re: error ora-44003 [message #585520 is a reply to message #585518] Mon, 27 May 2013 04:02 Go to previous messageGo to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
No, I did not delete the field and recreate it .

I had deleted the constrains , that is primary key and not null , in the supporting objects .

Then I recreated it , by again making the fedid to primary key and not null.

Re: error ora-44003 [message #585522 is a reply to message #585520] Mon, 27 May 2013 04:17 Go to previous messageGo to next message
Littlefoot
Messages: 19636
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In supporting objects? Which Apex version do you use?

On Apex 4.1, I tried to simulate why you said:
  • created a table:
    create table a1_test
    (id  number constraint pk_test primary key,
     ime varchar2(20));
  • created a form with report, using Wizard
  • ran the form, inserted a record
  • dropped the constraint
    alter table a1_test drop constraint pk_test; 
  • ran the form again, inserted another record
  • set the ID item "hidden"
  • ran the form again, inserted yet another record (whose ID column is now, obviously, empty)
  • recreated the primary key constraint:
    alter table a1_test add constraint
      pk_test primary key (id) 
      enable novalidate;
  • set the ID column to be a "text" item again
  • ran the form, inserted 4th record
Everything worked just fine, no problems at all.

If you could explain, step by step, what you did, maybe it would be easier to assist. Or, create an application on apex.oracle.com (you can get a free workspace there; let us know credentials so that we could access it). The way it is now, I still have no idea what went wrong.
Re: error ora-44003 [message #585531 is a reply to message #585522] Mon, 27 May 2013 05:03 Go to previous messageGo to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member



Thank a lot .

the url is http://10.33.88.40:8080/apex/f?p=103:1

username is rajesh
password is rajesh
Re: error ora-44003 [message #585538 is a reply to message #585531] Mon, 27 May 2013 05:23 Go to previous messageGo to next message
Littlefoot
Messages: 19636
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm afraid I can't access it - it is a private IP address.

apex.oracle.com is what I was talking about.
Re: error ora-44003 [message #586049 is a reply to message #585538] Mon, 03 June 2013 02:46 Go to previous messageGo to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
I have registered for a workspace in apex.oracle.com . however I did not receive the user id and password . so I can not develop the application here .

For the old application if I debug I get the following message .
Search:

Elapsed Execution Message Level
20130603101643.278000 0.29700 0.03100 S H O W: application="103" page="2" workspace="" request="" session="203914124136286" 4
20130603101643.309000 0.32800 0.00000 Reset NLS settings 4
20130603101643.309000 0.32800 0.00000 alter session set nls_language="AMERICAN" 4
20130603101643.309000 0.32800 0.00000 alter session set nls_territory="AMERICA" 4
20130603101643.309000 0.32800 0.04700 ...NLS: Set Decimal separator="." 4
20130603101643.356000 0.37500 0.00000 ...NLS: Set NLS Group separator="," 4
20130603101643.356000 0.37500 0.01600 ...NLS: Set g_nls_date_format="DD-MON-RR" 4
20130603101643.372000 0.39100 0.00000 ...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM" 4
20130603101643.372000 0.39100 0.00000 ...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR" 4
20130603101643.372000 0.39100 0.00000 ...Setting session time_zone to +03:00 4
20130603101643.372000 0.39100 0.03100 NLS: wwv_flow.g_flow_language_derived_from=0: wwv_flow.g_browser_language=en 4
20130603101643.403000 0.42200 0.01500 Application 103, Authentication: CUSTOM2, Page Template: 14127130401726404 4
20130603101643.418000 0.43700 0.00000 ...Session ID 203914124136286 can be used 4
20130603101643.418000 0.43700 0.00000 ...Application session: 203914124136286, user=ADMIN 4
20130603101643.418000 0.43700 0.01600 ...Determine if user "ADMIN" workspace "6988420415102907" can develop application "103" in workspace "6988420415102907" 4
20130603101643.418000 0.43700 0.00000 ...Check for session expiration: 4
20130603101643.434000 0.45300 0.01600 Session: Fetch session header information 4
20130603101643.450000 0.46900 0.00000 ...fetch session state from database 4
20130603101643.450000 0.46900 0.00000 fetch items 4
20130603101643.450000 0.46900 0.01500 ...fetched 14 session state items 4
20130603101643.465000 0.48400 0.00000 Branch point: Before Header 4
20130603101643.465000 0.48400 0.04700 Fetch application meta data 4
20130603101643.512000 0.53100 0.01600 Clear cache: request=2 4
20130603101643.528000 0.54700 0.00000 ...Clearing Cache for Page 2 4
20130603101643.528000 0.54700 0.18700 Nulling cache for application "103" page: 2 4
20130603101643.715000 0.73400 0.00000 ...metadata, fetch computations 4
20130603101643.715000 0.73400 0.01600 ...metadata, fetch buttons 4
20130603101643.731000 0.75000 0.00000 Computation point: Before Header 4
20130603101643.731000 0.75000 0.00000 Processing point: Before Header 4
20130603101643.731000 0.75000 0.00000 ...metadata, fetch item type settings 4
20130603101643.731000 0.75000 0.03100 ...metadata, fetch items 4
20130603101643.762000 0.78100 0.01600 Show page template header 4
20130603101643.778000 0.79700 0.00000 Computation point: After Header 4
20130603101643.778000 0.79700 0.01500 Processing point: After Header 4
20130603101643.793000 0.81200 0.00000 ...Process "Fetch Row from CARGO": DML_FETCH_ROW (AFTER_HEADER) F|#OWNER#:CARGO:P2_FEDID:FEDID 4
20130603101643.793000 0.81200 0.03200 Region: Breadcrumbs 4
20130603101643.825000 0.84400 0.00000 Computation point: Before Box Body 4
20130603101643.825000 0.84400 0.00000 Processing point: Before Box Body 4
20130603101643.825000 0.84400 0.03100 Region: Enter Data 4
20130603101643.856000 0.87500 0.00000 Item: P2_FEDID NATIVE_NUMBER_FIELD 4
20130603101643.856000 0.87500 0.03100 Item: P2_SHIPPING_BILL_NO NATIVE_NUMBER_FIELD 4
20130603101643.887000 0.90600 0.01600 Item: P2_MATERIAL_DETAILS NATIVE_TEXT_FIELD 4
20130603101643.903000 0.92200 0.01500 Item: P2_FROM NATIVE_SELECT_LIST 4
20130603101643.918000 0.93700 0.01600 Item: P2_RECEIVE_DATE NATIVE_DATE_PICKER_CLASSIC 4
20130603101643.934000 0.95300 0.01600 Item: P2_TOO NATIVE_SELECT_LIST 4
20130603101643.950000 0.96900 0.00000 Item: P2_SEND_DATE NATIVE_DATE_PICKER_CLASSIC 4
20130603101643.950000 0.96900 0.01500 Item: P2_FEDEX_NO NATIVE_NUMBER_FIELD 4
20130603101643.965000 0.98400 0.03200 Item: P2_U_NIT NATIVE_SELECT_LIST 4
20130603101643.997000 1.01600 0.01500 Item: P2_QTY NATIVE_NUMBER_FIELD 4
20130603101644.012000 1.03100 0.01600 Item: P2_R_EMARK NATIVE_TEXT_FIELD 4
20130603101644.028000 1.04700 0.03100 Item: P2_TMP_STMP NATIVE_DATE_PICKER 4
20130603101644.059000 1.07800 0.00000 Computation point: After Box Body 4
20130603101644.059000 1.07800 0.00000 Processing point: After Box Body 4
20130603101644.059000 1.07800 0.00000 Computation point: Before Footer 4
20130603101644.059000 1.07800 0.01600 Processing point: Before Footer 4
20130603101644.059000 1.07800 0.00000 Show page tempate footer 4
20130603101644.075000 1.09400 0.00000 Computation point: After Footer 4
20130603101644.075000 1.09400 0.00000 Processing point: After Footer 4
20130603101644.075000 1.09400 0.01500 Log Activity: 4
20130603101644.090000 1.10900 0.00000 v$sesstat.statistic# = 436: execute count=2 4
20130603101644.090000 1.10900 End Show Page 4





I have changed the create buuton to Save ( only label and text ) . Also I have changed it so that the cursor returns to page 2 ( after inserting to the base table ) . However it is not inserting data in the base table .

Please help ( Sorry for the trouble)
Re: error ora-44003 [message #586055 is a reply to message #586049] Mon, 03 June 2013 03:21 Go to previous messageGo to next message
Littlefoot
Messages: 19636
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's no error in debug information. However, this page did nothing (no insert). Do you have (under "Processes") automatic row processing (DML) process? If not, that might be a reason.
Re: error ora-44003 [message #586082 is a reply to message #586049] Mon, 03 June 2013 06:05 Go to previous messageGo to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
Pls find attached file .

DML is automatic .

Is there any problem with fedid .
Re: error ora-44003 [message #586126 is a reply to message #586082] Mon, 03 June 2013 15:04 Go to previous messageGo to next message
Littlefoot
Messages: 19636
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's nothing attached there.
Re: error ora-44003 [message #586132 is a reply to message #586126] Mon, 03 June 2013 23:40 Go to previous messageGo to next message
ariffcal
Messages: 100
Registered: April 2011
Senior Member
Pls find attached file .

DML is automatic .

Is there any problem with fedid .
  • Attachment: jjj.jpg
    (Size: 640.12KB, Downloaded 85 times)
Re: error ora-44003 [message #586150 is a reply to message #586132] Tue, 04 June 2013 02:14 Go to previous message
Littlefoot
Messages: 19636
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, so you have the process. I don't know whether there's a problem with FEDID.
Previous Topic: Apex
Next Topic: Workbench x Windows 8
Goto Forum:
  


Current Time: Tue Sep 23 09:38:09 CDT 2014

Total time taken to generate the page: 0.09654 seconds