Oracle 11gr2 error creating stored procedure with isolation level

I was used to MySql syntax, but now I'm trying to study Oracle. Let's take a look at the following stored procedure(using SQL Developer):

CREATE OR REPLACE PROCEDURE myPROC(aux OUT NUMBER, par1 IN VARCHAR2, par2 IN VARCHAR2) AS BEGIN COMMIT; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; --OR READ COMMITTED(any, does not matter) END myPROC;

I've read official documentation but I still cannot figure how to set isolation level for a stored procedure transaction or session. This code is compiled but with errors. How can something be successfully compiled, BUT with errors.

I have used show errors but still not very useful hints... Any advice? I have to mention that it's somehow pointing to the set transaction line...

Category:oracle Time:2018-11-10 Views:3
Tags: oracle plsql

Related post

  • Creating stored procedures with Joomla Custom Installer code API 2011-11-12

    Update: [Background info: I'm working on a Silverlight app which uses PHP code to interact with the MySql dbase. I have a regular installation package on www.mobilesportscoach.com (demo site on www.mobilesportscoach.com/test) which works well when yo

  • Can't create stored procedure with parameters 2013-05-30

    I'm trying to create a stored procedure with the in parameters first date, last date and country This is the normal query witch works just fine. SELECT CAR_TYPE.NAME, CAR_TYPE.TYPE, CAR.DAY_PRICE, CAR.REGISTRATION_NUMBER, AGENCY.NAME, BRANCH.NAME FRO

  • Creating Stored Procedure With Variable Number of Parameters 2011-02-06

    I want to create a SQL Server stored procedure with a varying number of parameters. It is similar to "params" in C#. How can I do it? --------------Solutions------------- Put them in an XML and try OPENXML feature. http://msdn.microsoft.com/en-us/lib

  • Creating Stored Procedures with SQLAlchemy 2010-07-27

    I am writing a python script to create the postgres database using SQLAlchemy. I also want to create Stored Procedures by same way. I checked the SQL Alchemy Documentations but was not able to find whether I can create stored procedure using it or no

  • Create stored procedure with CONTAINS in SQL Server 2008 2010-01-10

    I want to create a stored procedure to do some combined keyword search using CONTAINS,something like below: SELECT theContent FROM FtsTest WHERE CONTAINS (theContent, ' FORMSOF (INFLECTIONAL, keyword1) AND FORMSOF (INFLECTIONAL, keyword2)'); and he n

  • Creating stored procedure with declare and set variables 2012-02-11

    I am creating one stored procedure where only value has to pass and I have to retrieve multiple values from multiple tables. I tried to do like this but its showing error like Incorrect Syntax near Begin" and "Must declare the scalar variable "@Order

  • Error invoking stored procedure with input parameter from ADO.Net 2010-06-07

    I am using VSTS 2008 + C# + .Net 3.5 + ADO.Net. Here is my code and related error message. The error message says, @Param1 is not supplied, but actually it is supplied in my code. Any ideas what is wrong? System.Data.SqlClient.SqlException: Procedure

  • How create stored procedure with select and update 2011-11-18

    I have table id, title, showCount. I need get TOP 10 row from table and set to showCount +1. How do this? --------------Solutions------------- I can not understand your purpose, but you can try this CREATE TABLE #tbl (id int identity(1,1), title varc

  • calling stored procedure with Oracle data provider .net with two or more definitions (error PLS-00307) 2011-11-25

    I'm using Oracle Data Provider .net to interact with an Oracle database. I need to call a sample stored procedure but... The stored procedures is in an oracle package where there is another stored procedure with the same name and number of parameters

  • Call Oracle stored procedure with no arguments 2011-07-19

    I'm trying to call an Oracle stored procedure that accepts no input parameters. However, when running the procedure, I get an error back that states PLS-00306: wrong number or types of arguments in call to 'MY_PROC' To call the proc, I'm just enterin

  • How can I call an Oracle stored procedure with JDBC/Spring where some of the parameter types are user defined? 2010-08-17

    I'm trying to call an Oracle stored procedure from my Java program. I'm using JDBC and Spring's StoredProcedure. A couple of the parameters are user defined types and I need to know how to pass them in. In particular what type should I specify in the

  • Creating stored procedure in Mysql with BLOB variable in it 2011-12-29

    This is stored procedure that worked on earlier version of mysql. Now, I have Mysql 5.5.19.0 and I can not create stored procedure that look like this DELIMITER $$ USE `XXX`$$ DROP PROCEDURE IF EXISTS `current_to_prev`$$ CREATE DEFINER=`user`@`localh

  • DAO/ADO terminates Access application when we execute Oracle stored procedure with more than 9000 characters (aprox.) 2012-09-05

    Hi, I have recently migrated my MS Access application from Office 2003/XP to Office 2010 32bit / Win7 64bit. I use MS Access as my front-end and Oracle 11g as my back-end, and connected my application using ODBC driver Oracle 11g client. The problem

  • How to forcibly create stored procedure even if some error occurs? 2009-05-13

    When I execute database script, I got errors in stored procedure then it couldn't create that stored procedure that have errors. I want to forcibly create stored procedure even if some error occur in stored procedure. If some error occurred in the cr

  • Oracle Stored Procedure with out parameter using Nhibernate 2009-11-26

    How can I access the value of an out parameter of an oracle stored procedure in the .net code - Oracle stored procedure being called via Nhibernate? Sample working code would help. --------------Solutions------------- You have to use the latest versi

  • How to create a stored procedure with hibernate? 2012-01-02

    i was wondering if it's possible to create a stored procedure with hibernate ? or the available is that i can call procedures only ? please advise. --------------Solutions------------- If you are using DAO's or Repositories, or Managers for your enti

  • How do I create a stored procedure with Entity Framework? 2010-10-08

    I read an old MSDN Forums post about Entity Framework where Julie Lerman stated: wrt Stored Procedures. This is even better than what you are referring to. Not only can you map to sprocs (both in EF and in LINQ to SQL) or override the update/insert/d

  • Finding stored procedures with errors in SQL Server 2008? 2011-05-13

    I have a database which consists of almost 200 tables and 3000 stored procedures. I have deleted some fields from some tables, how can I now find stored procedures in which those deleted fields are referred? --------------Solutions------------- Have

  • Cannot execute stored procedure with ADO.NET Entity Framework 2009-04-26

    I've created a simple parameterless stored procedure which I've pasted below. I've imported the stored procedure to my Entity Model and created a Function Import. The function in the model is never created and I am unable to execute this stored proce

Copyright (C) pcaskme.com, All Rights Reserved.

processed in 0.754 (s). 13 q(s)