[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Dynamic Hint
- Subject: [sqr-users] Dynamic Hint
- From: "Thejus Giri" <thejus.giri@gmail.com>
- Date: Tue, 29 Apr 2008 14:40:03 +0530
- Delivery-date: Tue, 29 Apr 2008 05:13:07 -0400
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;bh=Wc0HZK8TmVv9dlNS8ZRYFkp8S2TbQwuL6WWjNhwDyos=;b=RXx2UkDxWf21vCIswaQsC+UNcd7ttoKIFZ6O794XTasLB7hOKbRnO8p53kIdL+1pd/Po41qS+JSo6twvLPFP8ohF493OxEo+3X3X1r53Ytc/EgVuCMngshCxgsmOb5gaHsVaiiJo3gCWDNLhQ+04+Gew/UM0RgMAhaJB7GYPjCU=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;b=VtiVCsszPYHWRw8SitUaUsuA98xd+/SIVxTi0NLn82qlPUf9Tvn04MG7TUAk04zZpq6xJectOkXNcY6eJ2okwuXI4RF3LGBlT04XcVgiNwwUyU7kMTzKq9kHgr8qiZnVJJoSNyfH5HuBUx4kVArRY/6TBkRmTmXKNHmLjp/9tk8=
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi
I am have the below statements for Dynamic hint in SQR
begin-select
/*+ ordered use_nl(t inv c) index_ffs(c i_charge_invoice)
parallel_index(c, i_charge_invoice, #HLINE) */
customer_node &c
.
.
.
end-select
#HLINE is fetch through another SQL sttement
When i compile, i am getting the error
(SQR 5528) ORACLE OCIBindByName error 1036 in cursor 2:
ORA-01036: illegal variable name/number
(SQR 1308) BNDCUR: Could not bind column 1.
Do anyone have any clue on this
Thanks in advance
Thejus
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users