OraFAQ Forum: Application Express, ORDS & MOD

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » apex (apex)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

apex [message #585100]

Wed, 22 May 2013 02:48

ariffcal
Messages: 107
Registered: April 2011

Senior Member

I have created a sequence for a table , cargo , for the column ,fedid .

However I can not link it with the table or column ,fedid .

I have a forms and interactive report for the base table, cargo .

fedid is a display only, field which should display the sequence no .

Pls help me in the above problem

Report message to a moderator

Re: apex [message #585103 is a reply to message #585100]

Wed, 22 May 2013 03:30

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, you created a sequence, but that's it - you can't dedicate it to a table or a column. You can use it so that its value is entered into that column, that's true. You can do it manually (INSERT INTO ... SEQUENCE_NAME.NEXTVAL), with a database trigger (SELECT SEQUENCE_NAME.NEXTVAL INTO :NEW.ID) or let Apex handle it.

If you want Apex to do that for you, "Create form page" asks for the primary key type. It can be ROWID or you can choose primary key column(s). If you chose ROWID, you can't select a sequence. Therefore, you need to choose primary key column option. Then you have to define the source for the primary key columns, which can be one of existing trigger (which you don't have), custom PL/SQL function (which you don't have either) or an existing sequence (which you, finally, have). So, choose it from the select list.

Report message to a moderator

Re: apex [message #586281 is a reply to message #585103]

Wed, 05 June 2013 03:03

ariffcal
Messages: 107
Registered: April 2011

Senior Member

I have deleted the fedid column from the table and forms .

I am getting the following error .

Pls let me know where this code is generated by apex ( i would like to delete it and see what happens) .

Please , note that I am doing this to be more familar with apex . I can drop the application and use the wizard and make the application from scartch ( which will be easier ) .

I am taking your help to learn more of apex ( pls do not mind , sorry about this ).

Thanks

ORA-20001: get_dbms_sql_cursor error ORA-00904: "FEDID": invalid identifier

Report message to a moderator

Re: apex [message #586282 is a reply to message #586281]

Wed, 05 June 2013 03:09

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

let me know where this code is generated by apex

Try to search for FEDID, here:

/forum/fa/10843/0/

Attachment: search_apex.JPG
(Size: 57.10KB, Downloaded 4063 times)

Report message to a moderator

Re: apex [message #586295 is a reply to message #586282]

Wed, 05 June 2013 03:32

ariffcal
Messages: 107
Registered: April 2011

Senior Member

Thank you very much .

I have found it , however I have a question , if I develop the application with the wizard and the customize it , I might be change the parameter for the appliaction ( ex . Like I want to drop a column , insert a column ) .

However , when I do this all the previous geneted code by apex does not get deleted ( how can I mange this problem ) .

Sorry , I troubled u again . please note that I am saying all the "thank you" and "sorry" in the correct time , so no more insults , thank u again , lol , hope u laugh with me

Report message to a moderator

Re: apex [message #586301 is a reply to message #586295]

Wed, 05 June 2013 03:43

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

when I do this all the previous geneted code by apex does not get deleted

When I do something like that, I use the "Search application" feature which returns all appearances of the dropped column and I fix them one by one.

If you add a column: for reports, it is more or less simple - you just add it to report's query and make it appear on the screen (for interactive reports, for example). Forms - you have to add these items manually. I prefer copying an existing item (whose source is a database column) and then adjusting that newly "copied" item's properties.

Report message to a moderator

Re: apex [message #586362 is a reply to message #586295]

Wed, 05 June 2013 08:23

ariffcal
Messages: 107
Registered: April 2011

Senior Member

HI ,

when I enter the save button . the action procccess message( system) does not appear .

the cursor is on the 1st field of the screen .

Can I set a break point in the debug , so that it stops after the click on the save buttton .

The data is not entered into the base table .

Can I set break points in apex debug and how to ?

Thanks

Report message to a moderator

Re: apex [message #586373 is a reply to message #586362]

Wed, 05 June 2013 11:15

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Breakpoints: I don't think so, but "View debug" information displays all processes that were (or were not, and why - for example, condition was not met) executed.

Report message to a moderator

condition for not inserting data in the table [message #586617 is a reply to message #586373]

Sat, 08 June 2013 02:42

ariffcal
Messages: 107
Registered: April 2011

Senior Member

Following are view debug .

Please let me know the condition ( or how to look for the condition ) . Why it is not inserting data in the base table ?

It is also not showing the system message "action proccessed " .

0.14000 0.12500 S H O W: application="103" page="2" workspace="" request="" session="7578988961455270" 4
0.26500 0.03200 Reset NLS settings 4
0.29700 0.01500 alter session set nls_language="AMERICAN" 4
0.31200 0.00000 alter session set nls_territory="AMERICA" 4
0.31200 0.01600 ...NLS: Set Decimal separator="." 4
0.32800 0.00000 ...NLS: Set NLS Group separator="," 4
0.32800 0.00000 ...NLS: Set g_nls_date_format="DD-MON-RR" 4
0.32800 0.01500 ...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM" 4
0.34300 0.00000 ...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR" 4
0.34300 0.00000 ...Setting session time_zone to +03:00 4
0.34300 0.00000 NLS: wwv_flow.g_flow_language_derived_from=0: wwv_flow.g_browser_language=en 4
0.34300 0.01600 Application 103, Authentication: CUSTOM2, Page Template: 14127130401726404 4
0.35900 0.01600 ...Session ID 7578988961455270 can be used 4
0.37500 0.01500 ...Application session: 7578988961455270, user=ADMIN 4
0.39000 0.03200 ...Determine if user "ADMIN" workspace "6988420415102907" can develop application "103" in workspace "6988420415102907" 4
0.42200 0.04600 ...Check for session expiration: 4
0.46800 0.11000 Session: Fetch session header information 4
0.57800 0.01500 ...fetch session state from database 4
0.59300 0.01600 fetch items 4
0.60900 0.04700 ...fetched 2 session state items 4
0.65600 0.04700 Branch point: Before Header 4
0.70300 0.25000 Fetch application meta data 4
0.95300 0.10900 ...metadata, fetch computations 4
1.06200 0.06300 ...metadata, fetch buttons 4
1.12500 0.00000 Computation point: Before Header 4
1.12500 0.01500 Processing point: Before Header 4
1.14000 0.07800 ...metadata, fetch item type settings 4
1.21800 0.57900 ...metadata, fetch items 4
1.79700 0.03100 Show page template header 4
1.82800 0.01500 Computation point: After Header 4
1.84300 0.00000 Processing point: After Header 4
1.84300 0.06300 ...Process "Fetch Row from CARGO": DML_FETCH_ROW (AFTER_HEADER) F|#OWNER#:CARGO:P2_SHIPPING_BILL_NO:SHIPPING_BILL_NO 4
1.90600 0.12500 Region: Breadcrumbs 4
2.03100 0.01600 Computation point: Before Box Body 4
2.04700 0.04600 Processing point: Before Box Body 4
2.09300 0.06300 Region: Enter Data 4
2.15600 0.03100 Item: P2_SHIPPING_BILL_NO NATIVE_NUMBER_FIELD 4
2.18700 0.00000 Item: P2_MATERIAL_DETAILS NATIVE_TEXT_FIELD 4
2.18700 0.15600 Item: P2_FROM NATIVE_SELECT_LIST 4
2.34300 0.01600 Item: P2_RECEIVE_DATE NATIVE_DATE_PICKER_CLASSIC 4
2.35900 0.01600 Item: P2_TOO NATIVE_SELECT_LIST 4
2.37500 0.03100 Item: P2_SEND_DATE NATIVE_DATE_PICKER_CLASSIC 4
2.40600 0.00000 Item: P2_FEDEX_NO NATIVE_NUMBER_FIELD 4
2.40600 0.04700 Item: P2_U_NIT NATIVE_SELECT_LIST 4
2.45300 0.00000 Item: P2_QTY NATIVE_NUMBER_FIELD 4
2.45300 0.01500 Item: P2_R_EMARK NATIVE_TEXT_FIELD 4
2.46800 0.01600 Item: P2_TMP_STMP NATIVE_DATE_PICKER 4
2.48400 0.00000 Computation point: After Box Body 4
2.48400 0.00000 Processing point: After Box Body 4
2.48400 0.03100 Computation point: Before Footer 4
2.51500 0.00000 Processing point: Before Footer 4
2.51500 0.12500 Show page tempate footer 4
2.64000 0.01600 Computation point: After Footer 4
2.65600 0.00000 Processing point: After Footer 4
2.65600 0.06200 Log Activity: 4
2.71800 0.00000 v$sesstat.statistic# = 436: execute count=2 4
2.71800 - End Show Page 4 -

1 - 57

Report message to a moderator

Re: condition for not inserting data in the table [message #586668 is a reply to message #586617]

Sun, 09 June 2013 06:38

ariffcal
Messages: 107
Registered: April 2011

Senior Member

gettting following error when inserting data from forms

103:2 - ORA-44003: invalid SQL name33 minutes ago4000:514 - ORA-20000: User ADMIN ha3 hours ago103:2 - ORA-01403: no data found AD3 hours ago103:2 - ORA-44003: invalid SQL name3 hours

Report message to a moderator

Re: condition for not inserting data in the table [message #586675 is a reply to message #586668]

Sun, 09 June 2013 07:07

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Debug code you posted didn't process anything. There's only "Fetch row from CARGO", which is SELECT. There's no INSERT there. As if you clicked a dummy button (which does absolutely nothing).

Report message to a moderator

Re: apex [message #586679 is a reply to message #585100]

Sun, 09 June 2013 08:22

ariffcal
Messages: 107
Registered: April 2011

Senior Member

The following is the error message I get when I click Save button

ORA-44003: invalid SQL name

Unable to process row of table CARGO.

The below is the debug message

0.53100 0.03100 S H O W: application="103" page="2" workspace="" request="" session="4271419989641827" 4
0.56200 0.00000 Reset NLS settings 4
0.56200 0.00000 alter session set nls_language="AMERICAN" 4
0.56200 0.00000 alter session set nls_territory="AMERICA" 4
0.56200 0.00000 ...NLS: Set Decimal separator="." 4
0.57800 0.01600 ...NLS: Set NLS Group separator="," 4
0.57800 0.00000 ...NLS: Set g_nls_date_format="DD-MON-RR" 4
0.57800 0.00000 ...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM" 4
0.57800 0.01500 ...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR" 4
0.59300 0.00000 ...Setting session time_zone to +03:00 4
0.59300 0.00000 NLS: wwv_flow.g_flow_language_derived_from=0: wwv_flow.g_browser_language=en 4
0.59300 0.00000 Application 103, Authentication: CUSTOM2, Page Template: 14127130401726404 4
0.59300 0.01600 ...Session ID 4271419989641827 can be used 4
0.60900 0.00000 ...Application session: 4271419989641827, user=ADMIN 4
0.60900 0.00000 ...Determine if user "ADMIN" workspace "6988420415102907" can develop application "103" in workspace "6988420415102907" 4
0.60900 0.00000 ...Check for session expiration: 4
0.60900 0.01600 Session: Fetch session header information 4
0.62500 0.00000 ...fetch session state from database 4
0.62500 0.00000 fetch items 4
0.64000 0.01500 ...fetched 13 session state items 4
0.64000 0.00000 Branch point: Before Header 4
0.64000 0.01600 Fetch application meta data 4
0.65600 0.00000 ...metadata, fetch computations 4
0.65600 0.00000 ...metadata, fetch buttons 4
0.65600 0.01600 Computation point: Before Header 4
0.67200 0.00000 Processing point: Before Header 4
0.67200 0.00000 ...metadata, fetch item type settings 4
0.67200 0.01500 ...metadata, fetch items 4
0.68700 0.01600 Show page template header 4
0.70300 0.00000 Computation point: After Header 4
0.70300 0.00000 Processing point: After Header 4
0.70300 0.82800 ...Process "Fetch Row from CARGO": DML_FETCH_ROW (AFTER_HEADER) F|#OWNER#:CARGO:P2_SHIPPING_BILL_NO:SHIPPING_BILL_NO 4
1.53100 0.03100 Show ERROR page... 4
1.56200 0.03100 Performing rollback... 4
1.59300 0.01600 Processing point: After Error Header 4
1.60900 0.00000 Region: Breadcrumbs 4
1.60900 0.04700 Processing point: Before Error Footer 4
1.65600 - ...Determine if user "ADMIN" workspace "6988420415102907" can develop application "103" in workspace "6988420415102907" 4 -

1 - 38

In debug errors I am getting ( when error button pressed )ORA-01403: no data found ADMIN 2 10 minutes ago
ORA-44003: invalid SQL name ADMIN 2 11 minutes ago
ORA-44003: invalid SQL name ADMIN 2 2 hours ago
ORA-01403: no data found ADMIN 2 4 hours ago
ORA-44003: invalid SQL name ADMIN 2 4 hours ago
ORA-44003: invalid SQL name ADMIN 2 4 hours ago
ORA-44003: invalid SQL name ADMIN 2 4 hours ago
ORA-44003: invalid SQL name ADMIN 2 4 hours ago

1st whn I click save button it gives

ORA-44003: invalid SQL name

1 - 8

Then

ORA-01403: no data found
Unable to fetch row.

Pls find the save button image attached .

Pls help

Attachment: save.jpg
(Size: 640.12KB, Downloaded 2071 times)

Report message to a moderator

Re: apex [message #586695 is a reply to message #586679]

Mon, 10 June 2013 01:13

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm sorry, but I don't know what caused that error (invalid SQL name).

Previously, you saidQuote:

I am doing this to be more familiar with apex

Maybe just a suggestion: create a new page, but use wizard this time. It will create all necessary code (processes, validations, whatever) and your form will run (at least, I hope so).

Then create a new, blank page, and start adding its components, one by one. Test frequently. Don't move on until you fix errors that appear. If you are unsure of what to do, compare your code with a page wizard created. Hopefully, you'll make it work.

Report message to a moderator

Previous Topic:	Apex forms
Next Topic:	How to hide Items values in browser URL.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 13:10:14 CST 2024