Re: Procedure problem between difference version.

Sorry for my inconvenience cause.

When I create RenameDir procedure on Oracle 8.0.6 for NT, I got this error:

   "MGR-00072: Warning: PROCEDURE RENAME created with compilation errors."

Hope you can help. Thank you very much.

--
Best regards,
Diviner.




> "Diviner" <diviner_at_hknet.com> wrote in message

> news:3B0CD892.3E36F6BE_at_hknet.com...

> I am using an Oracle8i 8.1.6 for Linux and work well. For some reason

> I want to make a copy of the database from Linux to NT. My Oracle

> for NT is version 8.0.6.

> The case is that, I find some procedure cannot migrade from Linux to

> NT. A procedure coding can work well in Linux but has compiled error

> in NT. The coding are:

> create or replace procedure RenameDir(pRefNo in DocIndex.RefNo%type,

>   pFolderName in DocIndex.Filename%type)

> as

>  vPhyPath DocIndex.PhyPath%type;

>  newPhyPath DocIndex.PhyPath%type;

> begin

>  -- Determine new phypath value

>  select PhyPath into vPhyPath from DocIndex

>    where RefNo = pRefNo;

>


>  -- Update statement: Part 1

>  Update DocIndex set Filename = pFolderName

>    where RefNo = pRefNo;

>


>  -- Update statement: Part 2

>  newPhyPath := UpdatePath(vPhyPath, pFolderName);

>  Update DocIndex set PhyPath = Replace(PhyPath, vPhyPath, newPhyPath)

>    where PhyPath like '%' || vPhyPath || '%';

> end;

> And another one:

> create unique index idx_UserAcc on UserAcc(Company, Upper(Login));

>


> Hope you can help me. Thank you very much.

> --

> Best regards,

> Diviner.

>


> As you don't specify which compile error you are getting, do not expect to

> get any useful responses.

>


> As to your second query: as you don't post the explicit error, I can only

> guess.

> You are trying to create a function based index.

> As function based indexes are an Oracle 8i feature, do not expect them to

> work in 8.0.

>


> Could you also please post in plain text instead of in html.

> Many newsreaders can't read html

>


> Regards,

>


> Sybrand Bakker, Oracle DBA