This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I try to get data from store procedure in oracle DB (in sqlserver its work well). I get the all list of records(15) but the data of the all records is the same, The all records equal the first record. someone know where I am mistake?
Here is the code: DB code:
create or replace procedure GetTestTable(results out SYS_REFCURSOR) is begin open results for select * from testtbl; end GetTestTable;
Entity code:
[Serializable]
public System.Collections.Generic.IList<GettesttableResult> Gettesttable()
Call to procedure code:
private static void OracleConsoleTest() }
|
|
|
Most likely the stored procedure is not returning a column named "Id", or is always returning the same value for Id. In order to materialise entities, LightSpeed needs an Id column containing unique values. If the procedure is returning a unique key but that unique key is not named Id then you must specify the Identity Column Name on the entity to tell LightSpeed the name of the unique key. |
|