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 have created a temp table in Oracle as the following: create global temporary table TEMP When I try to add an entity to the table as the following: I get ORA-00942:table or view does not exist Does Lightspeed support temp tables? |
|
|
|
|
When you do a SaveChanges, for each entity that's been added to the unit of work, LightSpeed generates an INSERT statement. So provided Oracle's temp tables can be addressed using a normal SQL INSERT statement, LightSpeed will support them. However, you may need to give LightSpeed some help in working out how the table is to be addressed. At the moment I imagine LightSpeed is generating the following: INSERT ... INTO Temp (You can check this by setting LightSpeedContext.Logger.) Unfortunately I'm not sufficiently familiar with Oracle to know whether this is the correct syntax for addressing global temp tables. For example, do you need a prefix on the table name to specify an owner, e.g.: INSERT ... INTO global.Temp If so you can do this via the TableAttribute.Schema setting (Schema Name in the designer) on the Temp entity. The other thing to check may be the LightSpeedContext.PluralizeTableNames setting. |
|
|
|
