Errors about installing on Oracle9.2

heiheben
2010-09-10
2013-05-28
  • heiheben
    heiheben
    2010-09-10

    SQL> @json_v09_2\install.sql
    DOC>This software has been released under the MIT license:
    DOC>
    DOC>  Copyright (C) 2009 Jonas Krogsboell inspired by code from Lewis R Cunningham
    DOC>
    DOC>  Permission is hereby granted, free of charge, to any person obtaining a copy
    DOC>  of this software and associated documentation files (the "Software"), to deal
    DOC>  in the Software without restriction, including without limitation the rights
    DOC>  to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
    DOC>  copies of the Software, and to permit persons to whom the Software is
    DOC>  furnished to do so, subject to the following conditions:
    DOC>
    DOC>  The above copyright notice and this permission notice shall be included in
    DOC>  all copies or substantial portions of the Software.
    DOC>
    DOC>  THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
    DOC>  IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
    DOC>  FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
    DOC>  AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
    DOC>  LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
    DOC>  OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
    DOC>  THE SOFTWARE.
    DOC>*/


    - Compiling objects for PL/JSON -

    DOC>  Copyright (C) 2010 Jonas Krogsboell
    DOC>
    DOC>  Permission is hereby granted, free of charge, to any person obtaining a copy
    DOC>  of this software and associated documentation files (the "Software"), to deal
    DOC>  in the Software without restriction, including without limitation the rights
    DOC>  to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
    DOC>  copies of the Software, and to permit persons to whom the Software is
    DOC>  furnished to do so, subject to the following conditions:
    DOC>
    DOC>  The above copyright notice and this permission notice shall be included in
    DOC>  all copies or substantial portions of the Software.
    DOC>
    DOC>  THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
    DOC>  IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
    DOC>  FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
    DOC>  AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
    DOC>  LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
    DOC>  OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
    DOC>  THE SOFTWARE.
    DOC>  */

    PL/SQL 过程已成功完成。

    类型已创建。

    类型已创建。

    没有错误。

    类型已创建。

    没有错误。

    警告: 创建的类型带有编译错误。

    TYPE JSON 出现错误:

    LINE/COL

    ERROR

    41/61
    PLS-00103: 出现符号 "SET"在需要下列之一时:
    <an identifier>
       <a double-quoted delimited-identifier> current
    符号 "<an identifier>在 "SET" 继续之前已插入。

    警告: 创建的包带有编译错误。

    警告: 创建的包体带有编译错误。

    警告: 创建的包带有编译错误。

    警告: 创建的包体带有编译错误。

    警告: 创建的类型体带有编译错误。

    TYPE BODY JSON_VALUE 出现错误:

    LINE/COL

    ERROR

    108/7
    PL/SQL: Statement ignored

    108/14
    PLS-00905: 对象 CBS.JSON_PRINTER 无效

    110/7
    PL/SQL: Statement ignored

    110/14
    PLS-00905: 对象 CBS.JSON_PRINTER 无效

    117/7
    PLS-00905: 对象 CBS.JSON_PRINTER 无效

    117/7
    PL/SQL: Statement ignored

    119/7

    LINE/COL

    ERROR

    PLS-00905: 对象 CBS.JSON_PRINTER 无效

    119/7
    PL/SQL: Statement ignored

    警告: 创建的包带有编译错误。

    警告: 创建的包体带有编译错误。

    DOC>  Copyright (C) 2010 Jonas Krogsboell
    DOC>
    DOC>  Permission is hereby granted, free of charge, to any person obtaining a copy
    DOC>  of this software and associated documentation files (the "Software"), to deal
    DOC>  in the Software without restriction, including without limitation the rights
    DOC>  to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
    DOC>  copies of the Software, and to permit persons to whom the Software is
    DOC>  furnished to do so, subject to the following conditions:
    DOC>
    DOC>  The above copyright notice and this permission notice shall be included in
    DOC>  all copies or substantial portions of the Software.
    DOC>
    DOC>  THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
    DOC>  IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
    DOC>  FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
    DOC>  AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
    DOC>  LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
    DOC>  OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
    DOC>  THE SOFTWARE.
    DOC>*/

    警告: 创建的类型体带有编译错误。

    TYPE BODY JSON 出现错误:

    LINE/COL

    ERROR

    176/61
    PLS-00103: 出现符号 "SET"在需要下列之一时:
    <an identifier>
       <a double-quoted delimited-identifier> current
    符号 "<an identifier>在 "SET" 继续之前已插入。

    178/8
    PLS-00103: 出现符号 "SET"在需要下列之一时:
    ( - + case mod new not null
       others <an identifier> <a double-quoted delimited-identifier>
       <a bind variable> avg count current exists max min prior sql
       stddev sum variance execute forall merge time timestamp
       interval date
       <a string literal with character set specification>
       <a number> <a single-quoted SQL string> pipe
    符号 "null在 "SET" 继续之前已插入。

    DOC>  Copyright (C) 2009 Jonas Krogsboell
    DOC>
    DOC>  Permission is hereby granted, free of charge, to any person obtaining a copy
    DOC>  of this software and associated documentation files (the "Software"), to deal
    DOC>  in the Software without restriction, including without limitation the rights
    DOC>  to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
    DOC>  copies of the Software, and to permit persons to whom the Software is
    DOC>  furnished to do so, subject to the following conditions:
    DOC>
    DOC>  The above copyright notice and this permission notice shall be included in
    DOC>  all copies or substantial portions of the Software.
    DOC>
    DOC>  THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
    DOC>  IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
    DOC>  FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
    DOC>  AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
    DOC>  LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
    DOC>  OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
    DOC>  THE SOFTWARE.
    DOC>  */

    警告: 创建的类型体带有编译错误。

    TYPE BODY JSON_LIST 出现错误:

    LINE/COL

    ERROR

    11/5
    PL/SQL: Statement ignored

    11/13
    PLS-00905: 对象 CBS.JSON_PARSER 无效

    17/5
    PL/SQL: Statement ignored

    17/13
    PLS-00905: 对象 CBS.JSON_PARSER 无效

    192/7
    PL/SQL: Statement ignored

    192/14
    PLS-00905: 对象 CBS.JSON_PRINTER 无效

    194/7

    LINE/COL

    ERROR

    PL/SQL: Statement ignored

    194/14
    PLS-00905: 对象 CBS.JSON_PRINTER 无效

    201/7
    PLS-00905: 对象 CBS.JSON_PRINTER 无效

    201/7
    PL/SQL: Statement ignored

    203/7
    PLS-00905: 对象 CBS.JSON_PRINTER 无效

    203/7
    PL/SQL: Statement ignored

    216/5
    PL/SQL: Statement ignored

    LINE/COL

    ERROR

    216/12
    PLS-00905: 对象 CBS.JSON_EXT 无效

    221/13
    PLS-00905: 对象 CBS.JSON 无效

    221/13
    PL/SQL: Item ignored

    223/5
    PL/SQL: Statement ignored

    223/18
    PLS-00320: 此表达式的类型说明不完整或格式不正确

    224/5
    PL/SQL: Statement ignored

    LINE/COL

    ERROR

    224/13
    PLS-00320: 此表达式的类型说明不完整或格式不正确


    - Adding optional packages for PL/JSON -

    SQL>

     
  • Your japanese error messages doesn't make much sense to me. What database version are you trying to install pl/json on?

     
  • heiheben
    heiheben
    2010-09-15

    Error messages  with some Chinese , not Japanese
    I want to install pljson on oracle9.2
    who can give compatible relations between pljson version and oracle version