日期:2014-05-17  浏览次数:20783 次

如何在triggers中调用系统变量?
如何在triggers中调用系统变量?
ebs 11.0.3 reports二次开发,我在AFTERPFORM(Function Body)中有用这样一条语句:
oneRow:= '打印时间:'||to_char(&Current Date)||页数||to_char(&Logical Page Number);
TEXT_IO.PUT_LINE(outFile,oneRow);
report developer2000报错:
Error 103 at line 479,column 8
  Encountered the symbol "|" when expecting one of the following:
  "(" "." "+" "mod" "null" <an identifier>
  <a double-quoted string><a bind variable><a number>
  <a single-quoted SQL string> "avg" "count" "max" "min"
  "prior" "sql" "stddev" "sum" "variance"
 null was inserted before "|" to continue.
应该怎么引用这个系统时间Current Date和页数Logical Page Number呢??????

------解决方案--------------------
MARK一下等待大牛解答
------解决方案--------------------
sys_context基本够用,我给你贴文档地址,你去瞅瞅:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions184.htm#SQLRF06117