TOM 3.1 no build possible

forum.team.object.manager (2000-2005) & forum.td.tom (2005-2010)
Krister Henningsson

TOM 3.1 no build possible

Post by Krister Henningsson » 02 Jun 2004, 11:50

 Posted by:  Krister Henningsson 

Does anyone have an idea?

ORA-01007: Variable nicht in der SELECT-Liste.
Native SQL error = 1007
SQL statement: ( ">>>>" shows location of error )
select P.PROMOTION_ID, N.PROMOTION_NAME
into :nPromotionLevel, :sPromotionName
from TMADM.PROMOTION_REVISION P, TMADM.PROMOTION N
where P.MODULE_ID = :nModuleId
And P.REVISION_NO = :nRevisionNo
And P.PROMOTION_ID = N.PROMOTION_ID

nPromotionLevel = 1
sPromotionName = 'Development'
nModuleId = 123
nRevisionNo = 1

--
Regards,
Kriss

FAQ-stuff
------------------------------------------------
OS: w2k/windowsXP
GUPTA: TD3.1
Client 9i (9.2)
Db: Oracle 8.1.7
------------------------------------------------

cschubert
Germany
Posts: 826
Joined: 23 May 2018, 11:26
Location: Germany

TOM 3.1 no build possible

Post by cschubert » 02 Jun 2004, 20:10

 Posted by:  Christian Schubert 

Krister,

I had some funny problems of similar kind because I used SUBSTITUTEs in my
SQL.INI which interfered with TOM's repository tables/columns...

HTH

Christian Schubert

Krister Henningsson

TOM 3.1 no build possible

Post by Krister Henningsson » 03 Jun 2004, 08:15

 Posted by:  Krister Henningsson 

Hi Christian,

Thanks for your suggestion,

However, I commented out ***uselob = 1*** and it worked again &:-).
We just started using TOM again after the move from 2.1 to 3.0 to 3.1
Our first encounter with TOM was discomforting to say the least.

again, thanks.

Kriss

Return to “td.tom”

Who is online

Users browsing this forum: [Ccbot] and 0 guests