Pl Sql Error 801
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Forms All PlacesDevelopment ToolsForms This discussion is archived 1 Reply Latest reply on Nov 6, 2010 10:55 AM by Christian Erlinger PL/SQL ERROR 801 rameshs Nov 5, 2010 4:55 PM Hi, I am receiving an internal error when I try to compile a form using the DBMS_SQL package on the application server. Environment: Database - 11.1.0.7 Forms 10.1 (Form Compiler) Version 10.1.2.3.0 Problem I have a form that uses the DBMS_SQL package in order to generate an extract file that can be downloaded to the client. When I try to compile the form on the application server, I receive the error - PL/SQL ERROR 801 at line 0, column 0 internal error [pht_resolve_type_name:kind] PL/SQL ERROR 0 at line 9, column 2 The form compiles fine on the desktop using the Form Builder, I have traced the problem to the line in the code where it uses the DBMS_SQL.DEFINE_COLUMN procedure. If I comment out this line, the form compiles fine. I created a test form that has nothing except a simple program unit that has a DBMS_SQL call and this form fails to compile as well. Has anyone run across this kind of issue? Thanks, Ramesh I have the same question Show 0 Likes(0) 552Views Tags: none (add) This content has been marked as final. Show 1 reply 1. Re: PL/SQL ERROR 801 Christian Erlinger Nov 6, 2010 10:55 AM (in response to rameshs) Dbms_sql should be used in database procedures;if you need to do dynamic sql in forms there would be the exec_sql package or you could use a record group.if there is really a need for Dbms_sql I'd put it inside a database procedure an
in below error Error 801 at line 0,column 0 internal error [[60604]]Solution:This error is caused when u make some changes in the form after either changing the table design at the back end (database block) or the connectivity to the server is disconnected for some time and u reconnect and compile.1. Save the Form and Close the Form Builder session2. Reopen the session, connect to Database and Open your Form3. Navigate to Program>Compile>All and compile all objects. Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest 3 comments: santosh dhongade said... This is strange error haven't come https://community.oracle.com/thread/2127689 across check on Oracle Metalink July 24, 2012 at 3:59 AM Anonymous said... Great, worked March 19, 2014 at 3:42 AM Marcel de Boer said... This solved it! Thank you! April 14, 2016 at 12:28 AM Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Labels DBA (6) Documentation (2) Fixed Assets (1) GRC (1) iExpense (2) OAF (2) Oracle ADI (2) Oracle http://www.oracleappsdeveloper.com/2012/05/oracle-forms-internal-error-60604.html Apps API (6) Oracle Conversion (2) Oracle Core Contract (2) Oracle Payables (2) Oracle Receivables (4) Oracle Workflow (4) Performance tuning (4) PLSQL (4) Property Manager (1) User guides (1) XML Interface (2) Blog Archive ► 2016 (5) ► March (1) ► February (3) ► January (1) ► 2015 (10) ► September (2) ► August (1) ► July (1) ► June (3) ► May (1) ► March (2) ► 2014 (3) ► May (1) ► February (1) ► January (1) ► 2013 (10) ► December (2) ► September (2) ► April (2) ► March (2) ► February (2) ▼ 2012 (46) ► December (3) ► November (3) ► October (1) ► September (5) ► August (3) ► July (3) ► June (2) ▼ May (3) Oracle Apps: Working with Oracle Forms Oracle Forms - internal error 60604 Starting your Oracle Apps Instance ► April (3) ► March (6) ► February (13) ► January (1) ► 2011 (3) ► May (3) ► 2007 (1) ► January (1) ► 2006 (1) ► December (1) OracleSearch Search this Site Loading... Follow by Email There was an error in this gadget Total Pageviews Picture Window template. Template images by gaffera. Powered by Blogger.
0 internal error [phd_get_defn:DI_U_NAM_RHS] Error 908 at line 0, column 0 The stored format of
be down. Please try the request again. Your cache administrator is webmaster. Generated Mon, 24 Oct 2016 07:58:20 GMT by s_wx1157 (squid/3.5.20)