Error Creating Pl Sql Object Writeline Procedure
the database schemas of SOA Suite using RCU - ofm_rcu_win_11.1.1.5.0 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: Error creating PL/SQL Object WRITE_LINE:PROCEDURE ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: Error creating PL/SQL Object DEBUG_PURGE:PROCEDURE Resolution Before running rcu, the variable RCU_JDBC_TRIM_BLOCKS should be set to TRUE in the OS Level. In windows, before running rcu.bat, run the below statement should be executed. %DCU_HOME%> set RCU_JDBC_TRIM_BLOCKS = TRUE 2. Ensure you use "sys" user while connecting from RCU. If you are using the any other user like system, then following grant should be given. SQL> grant execute on sys.dbms_lock to system with grant option Share this:TwitterFacebookLike this:Like Loading... Related About Ravishankar Palaniappan Oracle Certified SOA Consultant experienced in complex enterprise integration assignments using Oracle SOA. View all posts by Ravishankar Palaniappan » Post navigation ← Previous post Next post → Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogOut/Change) Cancel Connecting to %s Notify me of new comments via email. Search: Recent Posts Oracle Fusion Middleware Disaster RecoveryPoll Custom Hudson ServerDashboard Hudson Server: Access denied User is missing the Readpermission Oracle VM image for SOA/BPM11.1.1.6 Rich Client PlatformArchitecture Archives June 2012 May 2012 March 2012 January 2012 December 2011 November 2011 Contributers Thank you Visitors! Categories Land Preparation Others Seed Selection Uncategorized Create a free website or blog at WordPress.com. %d bloggers like this:
11g - Repository Creation Utility (RCU) July 3, 2009 / Database / By Atul Kumar / 63 COMMENTS This post covers overview of Repository Creation Utility(RCU) which is first thing you need to do, if you are planning to implement/install Oracle Fusion Middleware 11g R1 (11.1.1.0). Metadata Repository - contains metadata for Fusion Middleware Components (SOA, Webcenter, Identity Management) . There are various types of Repository - Metadata Services (MDS), Audit Services (IAU), Oracle Internet https://soafarm.wordpress.com/2011/12/08/error-creating-plsql-object-write_lineprocedure-rcu-ofm_rcu_win_11-1-1-5-0/ Directory (OID), Single Sign-On (SSO), SOA Infrastructure (SOAINFRA), Business Activity Monitoring (BAM) , User Messaging (ORASDPM) , Oracle WebCenter (WEBCENTER) , WebCenter Portlets (PORTLETS) , Oracle Content Server (OCSERVER) , Portal (PORTAL), Discoverer (DISCOVERER), Oracle Identity Federation (OIF) , Discussions (DISCUSSIONS) and Wiki and Blog (WIKI) Repository could be Database-based or File-based, most component (Webcenter, http://onlineappsdba.com/index.php/2009/07/03/oracle-fusion-middleware-11g-repository-creation-utility-rcu/ SOA, OID…) requires Database-based Repository. . How to create Database-based repository ? RCU - Repository Creation Utility is tool to create schema and load repository in existing database for Fusion Middleware components. Download RCU from here . Key points for Repository Creation Utility (RCU) in FMW 1. RCU can be run in two mode - GUI (Graphical User Interface) & CLI (Command Line Interface) 2. For Fusion Middleware 11g R1 (11.1.1.X) , RCU can only load schema in Oracle Database (version 10.2.0.4 and higher or 11.1.0.7 and higher) 3. You can run RCU locally (same machine where Database is running) or Remotely (Database is on remote machine) 4. By default RCU creates default schema and load repository in default tablespaces. RCU provides flexibility to change schema or tablespace name. (Only exception to this is Oracle Internet Directory (OID) schema) 5. You could load multiple repository (like Portal, webcenter, SOAINFRA) in single database. You could also load different version of same repository (like dev_soainfra, test_soainfra
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this http://stackoverflow.com/questions/11317789/pl-sql-error-when-creating-sequence site About Us Learn more about Stack Overflow the company Business Learn more http://www.oracletool.com/blog/?p=64 about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up PL/SQL: Error error creating when creating sequence up vote 5 down vote favorite I'm quite new to PL/SQL, and am using Oracle SQL Developer to write a procedure which uses a sequence to generate a primary key for some existing data, to write into another DB. The code in question is under NDA.. Essentially I have the following: create or replace PROCEDURE Generate_Data ( output IN VARCHAR2 ) error creating pl AS -- Variables here -- CURSOR myCursor IS SELECT data1, data2 FROM table; CREATE SEQUENCE mySequence <-- error on this line START WITH 0 INCREMENT BY 1; BEGIN LOOP -- snip -- It raises the error PLS-00103, saying it encountered the symbol CREATE when expecting on of the following: begin, function, package, pragma, procedure, ... I've been following the example at: http://www.techonthenet.com/oracle/sequences.php oracle plsql pls-00103 share|improve this question edited Jul 3 '12 at 20:56 asked Jul 3 '12 at 19:26 iank 314421 add a comment| 3 Answers 3 active oldest votes up vote 7 down vote accepted The reason you're getting this error is that you're trying to perform DDL, in this case creating a sequence, within PL/SQL. It is possible to do this, but you must use execute immediate. As Alex says, you also wouldn't be able to do this in the declare section. It would look something like this: begin execute immediate 'CREATE SEQUENCE mySequence START WITH 0 INCREMENT BY 1'; end; However, as Padmarag also says, it's highly unlikely that you want to do this within PL/SQL. It would be more normal to create a sequence out
on March 16, 2012 by Adam vonNieda Want to be able to send email from within Oracle, to multiple recipients, and with attachments? Well, allrightythen. The attachments will be taken from the OS, but this could be easily modified to take them from an Oracle table of your choosing. Some of this code I gathered from other places, and a bunch of it is mine. In the end, this is the most complete PL/SQL email sending package that I know of. When we're done, we'll have a package that looks like below, and we'll execute it as so.. Begin send_email.send( ToList=> 'adam@oracletool.com', Subject=>'Test email with attachments', Body=> 'Here is the body', FromEmail=>'Adam@Oracletool.com', FromHost=> 'Oracletool.com', SMTPServer=> 'localhost', AttachList=> 'send_email.sql,login.sql', Directory=>'ATTACHMENTS'); End; / 08:25:52 DEMO (ADAM) > Desc send_email; FUNCTION GET_MIME_TYPE RETURNS VARCHAR2 Argument NameTypeIn/Out Default? ------------------------------ ----------------------- ------ -------- FILENAME VARCHAR2IN PROCEDURE SEND Argument NameTypeIn/Out Default? ------------------------------ ----------------------- ------ -------- TOLIST VARCHAR2IN SUBJECTVARCHAR2IN BODY VARCHAR2IN FROMEMAILVARCHAR2IN DEFAULT FROMHOST VARCHAR2IN DEFAULT SMTPSERVER VARCHAR2IN DEFAULT ATTACHLIST VARCHAR2IN DEFAULT DIRECTORYVARCHAR2IN DEFAULT FUNCTION SPLIT RETURNS SPLIT_TBL Argument NameTypeIn/Out Default? ------------------------------ ----------------------- ------ -------- P_LIST VARCHAR2IN P_DELVARCHAR2IN DEFAULT Couple of prerequisites here. First of all, if you want to send attachments from the OS, you'll need to create an Oracle DIRECTORY object to point to the OS directory. Here's an example. Create or replace directory ATTACHMENTS as '/home/oracle/attachments'; You'll then reference that directory from the send_email package. Next, we need to allow our user to contact the email server, in this case, localhost, as I've got a local email server running that allows connections locally. If you're running Oracle 11.1.0.6 or greater, you'll need to create an ACL for the user, and we're going to use a great procedure I found for this called, you guessed it, create_acl from Metalink note# 557070.1. If you don't add an ACL, you'll be getting to know an error like "ORA-24247: network access denied by access control list (ACL)" This would be run as the "SYS" user, by the way. create or replace procedure create_acl( aacl varchar2, acomment varchar2, aprincipal varchar2, aisgrant boolean, aprivilege varchar2, aservervarchar2, aportnumber) is begin begin DBMS_NETWORK_ACL_ADMIN.DROP_ACL(aacl); dbms_output.put_line('ACL dropped.....'); exception when