Oracle Error 2117
Precompilations Separate Precompilations Compiling and Linking This chapter details the requirements for running the Oracle Precompilers. You learn what occurs during precompilation, how to issue the precompiler command, how to specify the many useful precompiler options, and how to do conditional and separate precompilations. The Precompiler Command To run an Oracle Precompiler, you issue one of the language-specific commands shown in Table 6-1. Table 6-1 Precompiler Command Host Language Precompiler Command COBOL procob FORTRAN profor The location of the precompiler differs from system to system. Typically, your system manager or DBA defines environment variables, logicals, or aliases or uses other operating system-specific means to make the precompiler executable accessible. The INAME option specifies the source file to be precompiled. For example, the Pro*COBOL command procob INAME=test precompiles the file test.pco in the current directory, since the precompiler assumes that the filename extension is .pco. You need not use a file extension when specifying INAME unless the extension is nonstandard. Input and output filenames need not be accompanied by their respective option names, INAME and ONAME. When the option names are not specified, the precompiler assumes that the first filename specified on the command line is the input filename and that the second filename is the output filename. Thus, the Pro*FORTRAN command profor MODE=ANSI myfile.pfo DBMS=V7 myfile.f is equivalent to profor MODE=ANSI INAME=myfile.pfo DBMS=V7 ONAME=myfile.f Note: Option names and option values that do not name specific operating system objects, such as filenames, are not case-sensitive. In the examples in this guide, option names are written in upper case, and option values are usually in lower case. Filenames, including the name of the precompiler executable itself, always follow the case conventions used by the operating system on which it is executed. What Occurs during Precompilation? During precompilation, an Oracle Precompiler generates host-language code that replaces the SQL statements embedded in your host program. The generated code includes data structures that contain the datatype, length, and address of each host variable, as well as other information required by the Oracle runtim
19Registered: February 2001 Junior Member Can anyone help me in finding an explanation for Oracle Error : ORA-2117 ? I dont find any explanation in Oracle Manual. Thanks! Report message to a moderator Re: ORA-2117 [message #2898 is a reply to message #2897] Tue, 20 August 2002 08:43 Mahesh Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator using pro*c?? pls post the exact error message and ur environment. Report https://docs.oracle.com/cd/B19306_01/appdev.102/b14354/chapter6.htm message to a moderator Re: ORA-2117 [message #2904 is a reply to message #2897] Tue, 20 August 2002 09:44 Gayathri Messages: 19Registered: February 2001 Junior Member Yes. The error is generated from Pro*C. Error Type : SQL Error Code : -2117 Error Message : ORA-02117: Message 2117 not found; product=RDBMS; facility=ORA The http://www.orafaq.com/forum/t/1165/0/ error occurs during runtime where cursor declaration and open is done. Report message to a moderator Previous Topic: temperal data Next Topic: PL/Sql tables Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab SuiteWeblogic & Application ServerBusiness IntelligenceWebCenter Suite & PortalCollaboration & Content ManagementSOA Suite, BPEL and OWSM- ApplicationsOracle Fusion Apps & E-Business SuitePeopleSoft, JD Edwards & SiebelPrimaveraOther Application Suites- InfrastructureHardwareUnixLinuxWindowsOther Operating Systems- Open SourceProgramming InterfacesMySQL- OtherGeneralTraining & CertificationMarketplaceCommunity HangoutSuggestions & FeedbackTest- Non-English ForumsArabicDutchFrenchGermanJapanesePortugueseRussianSpanish -=] Back to Top [=- [ Syndicate this forum (XML) ] [ ] Current Time: Sun Oct 23 12:06:22 CDT 2016 Total time taken to generate the page: 0.08397 seconds .:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.
vid Type in oracle error text* *e.g.username (at oracle error 2117 least 3 characters long) ora amd aud dbv drg epc exp img imp kup lcd lfi lpx lrm lsx mod ncr nid nmp nnc nnf nnl nno npl nze o2f o2i o2u pcb pcc pcf pls qsm rman sql sql*loader tns vid Error type information..... Search tips..... Oracle Support Copyright © Ora-error 2004-2012, all rights reserved.
DNS server returned: Name Error: The domain name does not exist. This means that the cache was not able to resolve the hostname presented in the URL. Check if the address is correct. Your cache administrator is webmaster. Generated Sun, 23 Oct 2016 19:06:23 GMT by s_wx1011 (squid/3.5.20)