今天写一个sql插入的时候出现了一个异常:PLS-306: wrong number or types of arguments in call to 'OGC_X'。上网找了找,发现一个真理:幸福的人都一样,不幸的人各有各的不幸。
于是自己好好研究了一下自己的sql:
select *
from (select a.agent_code agent_code,
a.user_name user_name,
c.name sub_company,
d.agent_level || '级' agent_level,
(case when
( select x.check_state
from vzzjzgl_apply x
where x.agent_code = a.agent_code ) = '01'
then trim('已授权')
else trim('未授权')
end) is_grant,
(select xxx.grant_time
from vzzjzgl_apply xxx
where xxx.agent_code = a.agent_code) operate_time,
(case when (select x.operator
from vzzjzgl_apply xxxx
where xxxx.agent_code = a.agent_code
) is not null then (select x.operator
from vzzjzgl_apply xxxx
where xxxx.agent_code = a.agent_code)
else '---' end ) operator
from
agent_agent a
inner join party c on a.organ_code = c.id
inner join agent_level d on a.agent_level_code =
d.agent_level_code)
where 1 = 1
order by agent_code
不知道聪明细心的你有没有发现我的马大哈错误呢,仔细看看选择operator那段,知道原因了吧?我将vzzjzgl_apply的简称xxxx写成x了。
写下来只是告诉大家一声大概就是这样的毛病。希望我们以后都不要再犯。呵呵。
分享到:
相关推荐
NULL 博文链接:https://gembler.iteye.com/blog/346242
Patch 8922013: ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [17059], [0X93953434]
x 执行权限;对目录,是进入该目录 - 表示没有权限 形式 - rw- r-- r-- 其中 第一个是文件类型(-表普通文件,d表目录,l表软链接文件) 第2~4个是属主,生成文件时登录的人,权限最高,用u表示 第5~7个是属组...
with no FILE, or when FILE is - or stdin, read standard input Arguments : -1 : Fast compression (default) -9 : High compression -d : decompression (default for .lz4 extension) -z : force ...
(note: You can add command line arguments according to the source code, for example $ python main.py --batch_size 64 ) ``` For the provided model, it took about 4 hours in GTX 1080TI. Here is my ...
到甲板 移到光明的一面! trello-to-deck从Trello的JSON...trello-to-deck: error: the following arguments are required: input_json, nextcloud_instance, username, password 您必须提供参数input_json例如tre
MPCS-51300编译器 队员 Zhong Chu Tianda Liu 用法 python ekcc.py [-emit-ast -emit-llvm -jit -O] <input_file> [args] -emit-ast: save ast to <...[args] pass arguments to source code 要求 Python
$ ./quick-doc.py -husage: quick-doc.py [-h] [-i [INPUT]] [-o [OUTPUT]] [-hl HEADER_LEVEL]generate markdown documentation from quick shell script commentsoptional arguments: -h, --help show
TODO:根据定义的规格测试结构... nodes_in_graph帮助信息python3 produce_output.py --helpusage: produce_output.py [-h] nodes_in_graphgenerate a graphpositional arguments: nodes_in_graph an integer number
Spring Boot JSON 示例应用程序演示了PostgreSQL与本地JPA查询结合使用的JSON功能。 入门 系统要求 Java 8 Maven的3 PosygreSQL 9.x 建立资料库 连接到本地psql数据库...mvn spring-boot:run -Drun.jvmArguments=
arguments-target:[DOMElement,insertPosition] | DOMElement-tag:HTML标签名称属性:HTML属性,样式 property- $ parent:DOMElement- $:DOMElement 方法-HTML :(模板| $ target,模板)=> void-addHTML :...
亚信java笔试题 Jianshu-go 本项目尝试解析简书API。 编程语言:golang Installation ...[arguments...] VERSION: ___ ___ ___ ___ ___ ___ ___ /\ \ /\ \ /\ \ /\__\ /\ \ /\__\ /\__\ _\:\ \ _\:\ \ /::\
os-fast-reservoir 快速近似水库采样的Python实现。 安装 $ pip install os-fast-reservoir 用法 原料药 from os_fast_reservoir import ReservoirSampling ... optional arguments: -h, --help
概述 ... -t, --target : Target model number Optional Arguments: -b, --bssid : BSSID of target -W, --wps : Output possible WPS pin(s) only -G, --guest : Output possible guest WPA key(s
用法- uses : jrouly/scalafmt-native-action@v1 with : # Optional: Which version of scalafmt-native to use. # Default: 2.7.5 version : ' 2.7.5 ' # Optional: Arguments to be passed to scalafmt-native. # ...
clustering.py --helpusage: color_clustering.py [-h] -i IMG -k CLUSTERSoptional arguments:-h, --helpshow this help message and exit-i IMG, --img IMGImage path-k CLUSETERS, --clusters CLUSTERSNumber of ...
async'export default function MyUserInterface ( { id } : { id : string } ) { // :backhand_index_pointing_right: pass action and arguments into the array const response = useDispatchAsync ( ...
跳马侧踢 概括 Vault Sidekick是一个附加容器,可用作与Hashicorp 服务进行交互,检索机密(静态和动态)... a configuration file in json or yaml containing authentication arguments -ca-cert string the pat
Mismatched number of parameters in definition ---------------------定义中参数个数不匹配 Misplaced break ---------------------此处不应出现break语句 Misplaced continue ------------------------此处不应...
8)....Added: Showing call stacks for 2 new types of fatal memory errors 9)....Added: EMemLeaks._ReserveOutOfMemory to control reserve size of out of memory errors (default is 50 Mb) 10)..Added: ...