紹介マニアMoinMoin

OracleEBS

OracleForms

Oracle物理設計

tkprof

SELECT * FROM DUAL@[DBLINK名]

execute [プロシージャ名]@[DBLINK名]('引数')

http://www6.airnet.ne.jp/~dr_mkag/Oracle/plsql/sndmil.html

http://www.geocities.jp/hacker_musasi/plsql/plsql_commit.html

http://www.seshop.com/se/edu/shikaku/omo/miti/miti_plati10.asp?educat=platinum

http://www.mars.dti.ne.jp/~o-shin/new/kowaza/body1720.html

http://otn.oracle.co.jp/cgi-bin/non/msgview_r.cgi?communityid=otn-489965&bbsid=1&no=41567&view=8

http://www.alato.ne.jp/kazu-/vb/oracle_tip.htm

参考サイト

http://homepage2.nifty.com/sak/w_sak3/doc/sysbrd/sak3sql.htm

http://www.geocities.jp/principal_focus/

実際はOracleマニュアルの方が詳しい

簡易Tips

いわゆるprint文

prompt text

PL/SQLでは、

 BEGIN
 dbms_output.put_line ('text...');
 END

エラー時のメッセージ

タブ

右に文字列を埋める

SQLCODEよりメッセージを求める

西暦和暦変換

元号のカスタマイズはLXEGENを利用する。

PL/SQLからJavaの呼び出し

OracleJavaStoredProcedure

コレクションタイプ

ORACLEコレクション

バックアップ・リカバリー

RMAN によって行う RecoveryManager ユーザーズ・ガイドおよびリファレンス リリース 参照

PL/SQLとShell

CODE_NUMBER=`
sqlplus -s xxx/xxx << EOF
set heading off
set feedback off
variable a number
execute test(:a)
print a
EOF

関連リンク

公式

公式サポートはサポート料金が必要です。酷いプログラムを作成するよりは、おそらくサポート料金は安いと思います。(個人ではちょっと高いですが、、)

http://otn.oracle.com/

http://metalink.oracle.com/

http://support.oracle.co.jp/

非公式

http://www.orafaq.org/faq.htm

http://www.zx81.org.uk/

http://www.linux.or.jp/JF/JFdocs/Oracle-8-HOWTO.html

書籍

--> -->

SyntaxError

Non-ASCII character '\xa5' in file /home/ubuntu/prj/moindata/data/plugin/macro/ISBN.py on line 22, but no encoding declared; see http://python.org/dev/peps/pep-0263/ for details (ISBN.py, line 22)

If you want to report a bug, please save this page and attach it to your bug report.

Traceback

A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.

  1. /home/ubuntu/prj/sakitojp/moin/MoinMoin/request.py in run (self=<MoinMoin.request.RequestWSGI object>)

    1. 1205 self.page.send_page(self, msg=msg)
    2. 1206 else:
    3. 1207 handler(self.page.page_name, self)
    4. 1208
    5. 1209 # generate page footer (actions that do not want this footer use
    • handler = <function do_print>
    • self = <MoinMoin.request.RequestWSGI object>
    • self.page = <MoinMoin.Page.Page instance>
    • self.page.page_name = u'Oracle'
  2. /home/ubuntu/prj/sakitojp/moin/MoinMoin/wikiaction.py in do_print (pagename=u'Oracle', request=<MoinMoin.request.RequestWSGI object>)

    1. 486
    2. 487 def do_print(pagename, request):
    3. 488 do_show(pagename, request)
    4. 489
    5. 490
    • global do_show = <function do_show>
    • pagename = u'Oracle'
    • request = <MoinMoin.request.RequestWSGI object>
  3. /home/ubuntu/prj/sakitojp/moin/MoinMoin/wikiaction.py in do_show (pagename=u'Oracle', request=<MoinMoin.request.RequestWSGI object>)

    1. 463 except KeyError:
    2. 464 rev = 0
    3. 465 Page(request, pagename, rev=rev).send_page(request, count_hit=1)
    4. 466 else:
    5. 467 request.cacheable = 1
    • global Page = <class MoinMoin.Page.Page>
    • request = <MoinMoin.request.RequestWSGI object>
    • pagename = u'Oracle'
    • rev = 22
    • ).send_page undefined
    • count_hit undefined
  4. /home/ubuntu/prj/sakitojp/moin/MoinMoin/Page.py in send_page (self=<MoinMoin.Page.Page instance>, request=<MoinMoin.request.RequestWSGI object>, msg=u'<strong>Revision 22 as of 2004-04-04 00:42:33</strong><br>', **keywords={'count_hit': 1})

    1. 1254 format_args=pi_formatargs,
    2. 1255 do_cache=do_cache,
    3. 1256 start_line=pi_lines)
    4. 1257
    5. 1258 # check for pending footnotes
    • start_line undefined
    • pi_lines = 0
  5. /home/ubuntu/prj/sakitojp/moin/MoinMoin/Page.py in send_page_content (self=<MoinMoin.Page.Page instance>, request=<MoinMoin.request.RequestWSGI object>, Parser=<class MoinMoin.parser.wiki.Parser>, body=u'["OracleEBS"]\n\nOracleForms\n\n["Oracle\u7269\u7406\u8a2d\u8a08"]\n\ntkpr...t One on One Oracle)]]\n\n\n------\nCategoryDatabase\n', format_args='', do_cache=1, **kw={'start_line': 0})

    1. 1341
    2. 1342 if not (do_cache and self.canUseCache(Parser)):
    3. 1343 self.format(parser)
    4. 1344 else:
    5. 1345 try:
    • self = <MoinMoin.Page.Page instance>
    • self.format = <bound method Page.format of <MoinMoin.Page.Page instance>>
    • parser = <MoinMoin.parser.wiki.Parser instance>
  6. /home/ubuntu/prj/sakitojp/moin/MoinMoin/Page.py in format (self=<MoinMoin.Page.Page instance>, parser=<MoinMoin.parser.wiki.Parser instance>)

    1. 1365 def format(self, parser):
    2. 1366 """ Format and write page content without caching """
    3. 1367 parser.format(self.formatter)
    4. 1368
    5. 1369 def execute(self, request, parser, code):
    • parser = <MoinMoin.parser.wiki.Parser instance>
    • parser.format = <bound method Parser.format of <MoinMoin.parser.wiki.Parser instance>>
    • self = <MoinMoin.Page.Page instance>
    • self.formatter = <MoinMoin.formatter.text_html.Formatter instance>
  7. /home/ubuntu/prj/sakitojp/moin/MoinMoin/parser/wiki.py in format (self=<MoinMoin.parser.wiki.Parser instance>, formatter=<MoinMoin.formatter.text_html.Formatter instance>)

    1. 1098
    2. 1099 # Scan line, format and write
    3. 1100 formatted_line = self.scan(scan_re, line)
    4. 1101 self.request.write(formatted_line)
    5. 1102
    • formatted_line = u'<p class="line867">\n<h1 id="head-bd1aae96775f3a67f39a9e19dcadd536b5c34f37">\u66f8\u7c4d</h1>\n'
    • self = <MoinMoin.parser.wiki.Parser instance>
    • self.scan = <bound method Parser.scan of <MoinMoin.parser.wiki.Parser instance>>
    • scan_re = <_sre.SRE_Pattern object>
    • line = u'[[ISBN(1861004826 Expert One on One Oracle)]] '
  8. /home/ubuntu/prj/sakitojp/moin/MoinMoin/parser/wiki.py in scan (self=<MoinMoin.parser.wiki.Parser instance>, scan_re=<_sre.SRE_Pattern object>, line=u'[[ISBN(1861004826 Expert One on One Oracle)]] ')

    1. 874 self.in_table or self.in_list):
    2. 875 result.append(self.formatter.paragraph(1, css_class="line867"))
    3. 876 result.append(self.replace(match))
    4. 877 lastpos = match.end()
    5. 878
    • result = ['<p class="line867">']
    • result.append = <built-in method append of list object>
    • self = <MoinMoin.parser.wiki.Parser instance>
    • self.replace = <bound method Parser.replace of <MoinMoin.parser.wiki.Parser instance>>
    • match = <_sre.SRE_Match object>
  9. /home/ubuntu/prj/sakitojp/moin/MoinMoin/parser/wiki.py in replace (self=<MoinMoin.parser.wiki.Parser instance>, match=<_sre.SRE_Match object>)

    1. 903 # Get replace method and replece hit
    2. 904 replace = getattr(self, '_' + type + '_repl')
    3. 905 result.append(replace(hit))
    4. 906 return ''.join(result)
    5. 907 else:
    • result = []
    • result.append = <built-in method append of list object>
    • replace = <bound method Parser._macro_repl of <MoinMoin.parser.wiki.Parser instance>>
    • hit = u'[[ISBN(1861004826 Expert One on One Oracle)]]'
  10. /home/ubuntu/prj/sakitojp/moin/MoinMoin/parser/wiki.py in _macro_repl (self=<MoinMoin.parser.wiki.Parser instance>, word=u'[[ISBN(1861004826 Expert One on One Oracle)]]')

    1. 848 if self.macro is None:
    2. 849 self.macro = wikimacro.Macro(self)
    3. 850 return self.formatter.macro(self.macro, macro_name, args)
    4. 851
    5. 852 def scan(self, scan_re, line):
    • self = <MoinMoin.parser.wiki.Parser instance>
    • self.formatter = <MoinMoin.formatter.text_html.Formatter instance>
    • self.formatter.macro = <bound method Formatter.macro of <MoinMoin.formatter.text_html.Formatter instance>>
    • self.macro = <MoinMoin.wikimacro.Macro instance>
    • macro_name = u'ISBN'
    • args = u'1861004826 Expert One on One Oracle'
  11. /home/ubuntu/prj/sakitojp/moin/MoinMoin/formatter/base.py in macro (self=<MoinMoin.formatter.text_html.Formatter instance>, macro_obj=<MoinMoin.wikimacro.Macro instance>, name=u'ISBN', args=u'1861004826 Expert One on One Oracle')

    1. 288 def macro(self, macro_obj, name, args):
    2. 289 # call the macro
    3. 290 return macro_obj.execute(name, args)
    4. 291
    5. 292 def _get_bang_args(self, line):
    • macro_obj = <MoinMoin.wikimacro.Macro instance>
    • macro_obj.execute = <bound method Macro.execute of <MoinMoin.wikimacro.Macro instance>>
    • name = u'ISBN'
    • args = u'1861004826 Expert One on One Oracle'
  12. /home/ubuntu/prj/sakitojp/moin/MoinMoin/wikimacro.py in execute (self=<MoinMoin.wikimacro.Macro instance>, macro_name=u'ISBN', args=u'1861004826 Expert One on One Oracle')

    1. 108 self.name = macro_name
    2. 109 try:
    3. 110 execute = wikiutil.importPlugin(self.cfg, 'macro', macro_name)
    4. 111 except wikiutil.PluginMissingError:
    5. 112 try:
    • execute undefined
    • global wikiutil = <module 'MoinMoin.wikiutil' from '/home/ubuntu/prj/sakitojp/moin/MoinMoin/wikiutil.pyc'>
    • wikiutil.importPlugin = <function importPlugin>
    • self = <MoinMoin.wikimacro.Macro instance>
    • self.cfg = <sakito.Config instance>
    • macro_name = u'ISBN'
  13. /home/ubuntu/prj/sakitojp/moin/MoinMoin/wikiutil.py in importPlugin (cfg=<sakito.Config instance>, kind='macro', name=u'ISBN', function='execute')

    1. 802 """
    2. 803 try:
    3. 804 return importWikiPlugin(cfg, kind, name, function)
    4. 805 except PluginMissingError:
    5. 806 return importBuiltinPlugin(kind, name, function)
    • global importWikiPlugin = <function importWikiPlugin>
    • cfg = <sakito.Config instance>
    • kind = 'macro'
    • name = u'ISBN'
    • function = 'execute'
  14. /home/ubuntu/prj/sakitojp/moin/MoinMoin/wikiutil.py in importWikiPlugin (cfg=<sakito.Config instance>, kind='macro', name=u'ISBN', function='execute')

    1. 815 raise PluginMissingError
    2. 816 moduleName = '%s.plugin.%s.%s' % (cfg.siteid, kind, name)
    3. 817 return importNameFromPlugin(moduleName, function)
    4. 818
    5. 819
    • global importNameFromPlugin = <function importNameFromPlugin>
    • moduleName = u'sakito.plugin.macro.ISBN'
    • function = 'execute'
  15. /home/ubuntu/prj/sakitojp/moin/MoinMoin/wikiutil.py in importNameFromPlugin (moduleName=u'sakito.plugin.macro.ISBN', name='execute')

    1. 834 Raise PluginAttributeError if name does not exists.
    2. 835 """
    3. 836 module = __import__(moduleName, globals(), {}, [name])
    4. 837 try:
    5. 838 return getattr(module, name)
    • module undefined
    • builtin __import__ = <built-in function __import__>
    • moduleName = u'sakito.plugin.macro.ISBN'
    • builtin globals = <built-in function globals>
    • name = 'execute'

SyntaxError

Non-ASCII character '\xa5' in file /home/ubuntu/prj/moindata/data/plugin/macro/ISBN.py on line 22, but no encoding declared; see http://python.org/dev/peps/pep-0263/ for details (ISBN.py, line 22)

  • args = (r"Non-ASCII character '\xa5' in file /home/ubuntu/... http://python.org/dev/peps/pep-0263/ for details", ('/home/ubuntu/prj/moindata/data/plugin/macro/ISBN.py', 22, 0, None))
  • filename = '/home/ubuntu/prj/moindata/data/plugin/macro/ISBN.py'
  • lineno = 22
  • message = ''
  • msg = r"Non-ASCII character '\xa5' in file /home/ubuntu/... http://python.org/dev/peps/pep-0263/ for details"
  • offset = 0
  • print_file_and_line = None
  • text = None

System Details

  • Date: Fri, 29 Mar 2024 09:09:35 +0000
  • Platform: Linux sakitojp 5.4.0-1060-aws #63~18.04.1-Ubuntu SMP Mon Nov 15 14:31:31 UTC 2021 x86_64
  • Python: Python 2.7.17 (/opt/uwsgi/bin/uwsgi2)
  • MoinMoin: Release 1.5.9 (release)