apex [message #585100] |
Wed, 22 May 2013 02:48 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/889c0baa33de0b861effb637c9e07e97?s=64&d=mm&r=g) |
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
|
|
|
Re: apex [message #585103 is a reply to message #585100] |
Wed, 22 May 2013 03:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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.
|
|
|
|
|
Re: apex [message #586295 is a reply to message #586282] |
Wed, 05 June 2013 03:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/889c0baa33de0b861effb637c9e07e97?s=64&d=mm&r=g) |
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
|
|
|
|
|
|
|
|
|
Re: apex [message #586679 is a reply to message #585100] |
Sun, 09 June 2013 08:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/889c0baa33de0b861effb637c9e07e97?s=64&d=mm&r=g) |
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 1954 times)
|
|
|
Re: apex [message #586695 is a reply to message #586679] |
Mon, 10 June 2013 01:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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.
|
|
|