This is a migrated thread and some comments may be shown as answers.

[Solved] Reverse mapping and Packages folder

17 Answers 222 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

17 Answers, 1 is accepted

answered on 13 Oct 2010, 05:31 PM

i can return a ref cursor as entity by calling a SP from oracle but if i put the SP inside a package (YIELDS_REPORT_PKG), i get this error

Telerik.OpenAccess.RT.sql.SQLException: ORA-06550: line 1, column 7:

PLS-00201: identifier 'YIELDS_REPORT_PKG.YIELD' must be declared

ORA-06550: line 1, column 7:

public static class StoredProcedure

{

public static IEnumerable<Model.NavYieldsView> getYieldByDateModel(IObjectScope scope,DateTime? v_DATE_TO,DateTime? v_DATE_FROM,string v_STRMODEL)

{

//object v_CURSOR=new object();

List<NavYieldsView> v_CURSOR = new List<NavYieldsView>();

Query<Model.NavYieldsView> query = scope.GetSqlQuery<Model.NavYieldsView>("\"YIELDS_REPORT_PKG.YIELD\" ?,?,?,?", "DATE V_DATE_TO,DATE V_DATE_FROM,OUT.CURSOR V_CURSOR,VARCHAR V_STRMODEL");

QueryResultEnumerable<Model.NavYieldsView> res = query.ExecuteEnumerable(new object[] {v_DATE_TO,v_DATE_FROM,v_CURSOR,v_STRMODEL});

return res;

}

}}

Im using 2009.3.131 version

answered on 19 Oct 2010, 10:29 PM

as I stated in previous post I was able to run packages from openaccess, my issue now is that ExecuteEnumerable return only 13 rows.

here is my code:

public static IEnumerable<Model.NavYieldsView> getYieldByDateModel(IObjectScope scope,DateTime? v_DATE_TO,DateTime? v_DATE_FROM,string v_STRMODEL)

{

object v_CURSOR=new object();

Query<Model.NavYieldsView> query = scope.GetSqlQuery<Model.NavYieldsView>("YIELDS_REPORT_PKG.YIELD ?,?,?,?", "DATE V_DATE_TO,DATE V_DATE_FROM,OUT.CURSOR V_CURSOR,VARCHAR V_STRMODEL");

var res = query.ExecuteEnumerable(new object[] { v_DATE_TO, v_DATE_FROM, v_CURSOR, v_STRMODEL });

return res;

}

Then from the Context i cast the value as my Entity as follow:

public IEnumerable<NavYieldsView> NavYieldsView(DateTime? v_DATE_FROM, DateTime? v_DATE_TO, string v_STRMODEL)

{

return StoredProcedure.getYieldByDateModel(Scope, v_DATE_FROM, v_DATE_TO, v_STRMODEL);

}

this gives only the 13 first rows, could it be a limitation on output parameter return value size?, in my case im returning a ref cursor...
btw, if i test my package from plsql the ref cursor gives 63 rows.

regards.

Edit: I just find out executeenumarable trunc the string parameter at 256 max length only, when i need it to be 4000 chars length.
how can i pass a parameter this long?
regards.

Edit2: I just figured out using Longvarchar fix the problem, thanks!.