[opencms-dev] missing pl/sql procedures with genericsql install
mfoley5 at csc.com.au
mfoley5 at csc.com.au
Thu May 30 03:11:34 CEST 2002
Hi All,
I'd like to add my voice to this question --- we too are a bit concerned
about hidden issues in moving between the Oracle Oci / GenericSql
environments.
Dan - would you mind letting me know how you have configured WebLogic 6.1
to work with the Oracle Oci driver? I must be doing something wrong, since
I get a core dump on Solaris.
Regards, Mark
Mark Foley
__________________________________________________
CSC
212 Northbourne Ave, Braddon, ACT 2612
Ph: +61-2-62468487 Email: mfoley5 at csc.com.au
----------------------------------------------------------------------------------------
This email, including any attachments, is intended only for use by the
addressee(s) and may contain confidential and/or personal information and
may also be the subject of legal privilege. Any personal information
contained in this email is not to be used or disclosed for any purpose
other than the purpose for which you have received it. If you are not the
intended recipient, you must not disclose or use the information contained
in it. In this case, please let me know by return email, delete the message
permanently from your system and destroy any copies.
----------------------------------------------------------------------------------------
Dan Moore <Dan.Moore at xor.com>@www.opencms.org on 30/05/2002 05:39:06 AM
Please respond to opencms-dev at www.opencms.org
Sent by: owner-opencms-dev at www.opencms.org
To: <opencms-dev at www.opencms.org>
cc:
Subject: [opencms-dev] missing pl/sql procedures with genericsql install
Hi folks,
We are trying to get OpenCMS up and running in WebLogic 6.1 with Oracle as
the database. In order to avoid some of the setup headaches with WLS 6.1,
we used Tomcat (4.0.1 on NT) to run the setup servlets. The first time
we ran the setup, we used the OCI driver. The second time, we used the
genericSql driver.
However, with the OCI driver, a large number of PL/SQL packages were
installed. With the genericSql driver, no packages were installed. This
is cause for concern.
Does OpenCMS need the PL/SQL packages to use Oracle effectively?
I looked in the mailing list, but there was no recent mention of pl/sql
packages.
Thanks for your time,
Dan
PS Here's a list of the functions that were omitted on the second install:
FUNCTION accessCreate
FUNCTION accessLock
FUNCTION accessUnlock
FUNCTION accessProject
FUNCTION accessRead
FUNCTION accessWrite
FUNCTION accessOwner
FUNCTION accessOther
FUNCTION accessGroup
FUNCTION userInGroup
FUNCTION getGroupsOfUser
FUNCTION getParent (pGroupId NUMBER) RETURN NUMBER;
FUNCTION getParent(pResourceName VARCHAR2) RETURN VARCHAR2;
FUNCTION isManagerOfProject
FUNCTION getUsersOfGroup
FUNCTION getAllAccessibleProjects
FUNCTION onlineProject RETURN cms_projects%ROWTYPE;
FUNCTION onlineProject (pProjectId NUMBER) RETURN cms_projects%ROWTYPE;
FUNCTION ReadAllProperties
FUNCTION readFolderAcc
FUNCTION readFolder
FUNCTION readFileHeader(pUserId NUMBER, pProjectID NUMBER, pFileName
VARCHAR2) RETURN userTypes.anyCursor;
FUNCTION readFileHeader(pUserId NUMBER, pProjectID NUMBER, pOnlineProjectId
NUMBER, pFileName VARCHAR2) RETURN userTypes.anyCursor;
FUNCTION readFile(pUserId NUMBER, pProjectID NUMBER, pFileName VARCHAR2)
RETURN userTypes.anyCursor;
FUNCTION readFile(pUserId NUMBER, pProjectID NUMBER, pOnlineProjectId
NUMBER, pFileName VARCHAR2) RETURN userTypes.anyCursor;
FUNCTION readFileNoAccess(pUserId NUMBER, pProjectID NUMBER,
pOnlineProjectId NUMBER, pFileName VARCHAR2) RETURN userTypes.anyCursor;
FUNCTION getFilesInFolder(pUserId NUMBER, pProjectId NUMBER, pResourceName
VARCHAR2) RETURN userTypes.resourceTable;
FUNCTION getFoldersInFolder(pUserId NUMBER, pProjectId NUMBER,
pResourceName VARCHAR2) RETURN userTypes.anyCursor;
FUNCTION getParentId(pProjectID NUMBER, pResourceId NUMBER) RETURN NUMBER;
FUNCTION addInList(pAnyId NUMBER) RETURN BOOLEAN;
FUNCTION addInList(pId NUMBER) RETURN BOOLEAN;
FUNCTION addPathInList(pName VARCHAR2) RETURN BOOLEAN;
FUNCTION getErrMsg(pErrorCode NUMBER) RETURN VARCHAR2 IS
PROCEDURE createProject
PROCEDURE publishProject
PROCEDURE writeProperties(pUserId IN NUMBER, pProjectId IN NUMBER,
pResourceId IN NUMBER, pResourceType IN NUMBER, pPropertyInfo IN
userTypes.anyCursor);
PROCEDURE writeProperties(pProjectId IN NUMBER, pPropertyInfo IN
userTypes.anyCursor, pResourceId IN NUMBER, pResourceType IN NUMBER);
PROCEDURE writeProperty
PROCEDURE lockResource(pUserId IN NUMBER, pProjectId IN NUMBER, pFolderName
IN VARCHAR2, pForce IN VARCHAR2, pResource OUT userTypes.anyCursor);
PROCEDURE lockResource(pUserId IN NUMBER, pProjectId IN NUMBER,
pOnlineProject NUMBER, pFolderName IN VARCHAR2, pForce IN VARCHAR2);
PROCEDURE unlockResource(pUserId IN NUMBER, pProjectId IN NUMBER,
pFolderName IN VARCHAR2, pResource OUT userTypes.anyCursor);
PROCEDURE unlockResource(pUserId IN NUMBER, pProjectId IN NUMBER,
pOnlineProject IN NUMBER, pFolderName IN VARCHAR2);
PROCEDURE createFolder(pUserId NUMBER, pProjectId NUMBER, pParentResId
NUMBER, pFileId NUMBER,
pFolderName VARCHAR2, pFlags NUMBER);
PROCEDURE createFolder(pUserId IN NUMBER, pProjectId IN NUMBER,
pOnlineProjectId IN NUMBER,
pResource IN cms_resources%ROWTYPE, pParentId IN
NUMBER, pFolderName IN VARCHAR2,
oResource OUT userTypes.anyCursor);
PROCEDURE createFile(pProjectId IN NUMBER, pOnlineProjectId IN NUMBER,
pResource IN userTypes.fileRecord, pUserId IN NUMBER,
pParentId IN NUMBER, pFileName IN VARCHAR2, pCopy
IN VARCHAR2, oResource OUT userTypes.anyCursor);
PROCEDURE removeFolder(pUserId NUMBER, pProjectId NUMBER, pResourceID
NUMBER, pResourceName VARCHAR2);
PROCEDURE writeFolder(pProjectID IN NUMBER, pResource IN
cms_resources%ROWTYPE, pChange IN VARCHAR2);
PROCEDURE writeFolder(pProjectID IN NUMBER, pResource IN
cms_resources%ROWTYPE, pChange IN VARCHAR2, pUserId IN NUMBER);
PROCEDURE writeFileHeader(pProjectID IN NUMBER, pResource IN
cms_resources%ROWTYPE, pChange IN VARCHAR2);
PROCEDURE writeFileHeader(pProjectID IN NUMBER, pResource IN
cms_resources%ROWTYPE, pChange IN VARCHAR2, pUserId IN NUMBER);
PROCEDURE writeFile(pProjectID IN NUMBER, pResource IN
userTypes.fileRecord, pChange IN VARCHAR2);
PROCEDURE writeFile(pProjectID IN NUMBER, pResource IN
userTypes.fileRecord, pChange IN VARCHAR2, pUserId IN NUMBER);
PROCEDURE copyFile(pProjectId NUMBER, pUserId NUMBER, pSource VARCHAR2,
pDestination VARCHAR2);
PROCEDURE chstate(pUserId IN NUMBER, pProjectId IN NUMBER, pResourceName IN
VARCHAR2, pState IN NUMBER);
PROCEDURE backupFolder(pProjectId IN NUMBER, pFolder IN
cms_resources%ROWTYPE, pVersionId IN NUMBER, pPublishDate IN DATE);
PROCEDURE backupFile(pProjectId IN NUMBER, pFile IN userTypes.fileRecord,
pVersionId IN NUMBER, pPublishDate IN DATE);
PROCEDURE removeTemporaryFiles(pFilename IN VARCHAR2);
PROCEDURE backupProject (pProjectId NUMBER, pVersionId NUMBER, pPublishDate
DATE, pUserId NUMBER);
PROCEDURE raiseUserError(pError IN NUMBER) is
More information about the opencms-dev
mailing list