最近备受01461问题困扰
metalink 上 有个解释,好像一个表如果有一个varchar2(4000)后, 如果还定义一个大于varchar2(1333)的column,那么在操作这个表时可能出这个错.
但我们伟大的developer 发现,只要你的pl/sql block 块里面有一个
大于varchar2(4000)的变量定义,并把它引用在DML语句中,oracle 在parse 时候就会报错,怪吧? 解决办法是DML之前就已经赋值到一个小于varchar2(4000)长度的变量里,问题解决,版本8.1.7.3,不知道其他版本会不会有类似问题,这个.. 算不算bug???
下面附上metalink 里ora-01461 解决方案供以后参考
Subject: Workarounds for bug 1400539: GETTING ORA-1461 INSERTING INTO A VARCHAR
Doc ID: Note:241358.1 Type: BULLETIN
Last Revision Date: 10-JUL-2006 Status: PUBLISHED
In this Document
Purpose
Scope and Application
Workarounds for bug 1400539: GETTING ORA-1461 INSERTING INTO A VARCHAR
References
_____
Applies to:
Oracle Server - Enterprise Edition - Version:
Information in this document applies to any platform.
Purpose
This note tries will describe reasons and workarounds for Bug 1400539. This bug describes the following problem:
Problem:
GETTING ORA-1461 WHEN INSERTING INTO A VARCHAR FIELD
Problem symptoms
* Using PRO*C or OCI.
* Database character set is set a multibyte character set. For example UTF8, AL32UTF8, JA16SJIS or JA16EUC.
* Trying to insert a VARCHAR2 into a column that is defined with a length of more than 1333 bytes.
* The same table either has another LONG column or at least 1 other VARCHAR2 with a length over 1333 bytes.
* NLS_LANG is set to a single-byte character set. For example american_america.WE8ISO8859P1)
Resulting error
ORA-1461: "can bind a LONG value only for insert into a LONG column"
Scope and Application
There are a number of ways to "hit" this bug, and some of the workarounds can be more or less relevant depending on the exact circumstances. However, in all cases the problem will be down to using a single byte client character set and a multibyte database character set. If that is not a setup you use then this is not a problem you have hit. If you indeed have a setup like that then there is a good chance that some of the workarounds given below will solve your problem.
Workarounds for bug 1400539: GETTING ORA-1461 INSERTING INTO A VARCHAR
Background
A character from the client character set (for example WE8ISO8859P1), can take up to 3 bytes of storage in the database character set UTF8 (we will focus on UTF8 here, but the same logic applies for other multi-byte character sets). That means that when you try to use this table from the client, the conversion ratio is set to 1:3. When connecting to a UTF8 server, then all character lengths are multiplied by 3 since this is the maximum length that the data could take up on the server.The maximum size of a VARCHAR2 is 4000 bytes. Anything bigger will be treated as a LONG. During run-time no check is made for the actual content of the columns. Even if a VARCHAR2(2000) column only contains 1 character, this is treated as if you're using a LONG (just like a LONG that contains only 1 character). If you have 1 of these columns plus a LONG, or simply 2 or more of these columns, effectively the database believes that you are binding 2 long columns. Since that is not allowed you receive this error.
The influence of NLS_LENGTH_SEMANTICS
NLS_LENGTH_SEMANTICS allows you to either set the size of columns in bytes or in characters, although internally most calculations are still based on bytes. If you define a column to be "VARCHAR2(20 CHAR)", we take the maximum length
that any character can be, and multiply the length by that. That way we get the maximum amount of bytes for that column. In UTF8 the maximum number of bytes for a character is 3. If you check DBA_TAB_COLUMNS you will see "DATA_LENGTH" is 60 for a "VARCHAR2(20 CHAR)" column. On top of that we also store the maximum number of characters (20) in the "CHAR_LENGTH" column. The logic of how you run into this bug applies to the DATA_LENGTH of a column, not the CHAR_LENGTH. So if you define the strings in terms of characters and define a column of "VARCHAR2(445 CHAR)", the DATA_LENGTH of that column will be 1335 and you might run into this problem (only if you have a LONG or another column like this in the same table of course). So where we talk about a maximum of 1333 bytes in this note, you could also read that as a maximum of 444 characters (in UTF8) if you choose to define lengths in characters.
Workarounds:
If you run into this problem there are 4 workarounds:
1. Limit the size of the buffer from within the OCI code
When you hit this problem in a OCI application you have control over, you should be able to work around it by setting the OCI_ATTR_MAXDATA_SIZE attribute of the bind variable to set the maximum size of the buffer that is used to 4000 bytes. That way there is a guarantee that the buffer will never exceed the size for a VARCHAR2, and therefore this problem cannot occur. You can set this attribute using a call to OCIAttrSet after you've done the bind (for example with OCIBindByName)
For example:
int maxdata_size = 4000;
...
OCIBindByName(stmthp1, &bnd1p, errhp, (oratext*)":ENAME",
(sb4) strlen((char *)":ENAME"), (void *) ename, sizeof(ename),
SQLT_STR, (void *)&insname_ind, (ub2 *) 0, (ub2 *) 0, (ub4) 0,
(ub4 *)0, OCI_DEFAULT);
OCIAttrSet((void *) bnd1p, (ub4) OCI_HTYPE_BIND, (void *) &maxdata_size, (ub4) 0,
(ub4) OCI_ATTR_MAXDATA_SIZE, errhp);
...
As you see in the example, after the bind statement we set the OCI_ATTR_MAXDATA_SIZE attribute of the bind variable to be "4000" (which is what maxdata_size is set to in the example). This means on that on the server side we will still treat this as a VARCHAR2 because the size does not exceed the maximum for that type.
2. Use the database character set also as the client character set This is possible for Web applications or other applications that can use Unicode/UTF8. If you application runs in the OS character set (ISO/ANSI/DEC/...) you cannot set the NLS_LANG to UTF8 unless the OS Locale itself runs in UTF-8. If you run on a Unix system, depending on what precise version and vendor, it might be possible to change the Unix Locale to UTF-8. Please see section 4 of Note 158577.1 for more information and links about that: If your application cannot use UTF8 then the best option is to use workaround 1 or 3.
3. Decrease the size of the columns
If you make sure that there is only 1 LONG and no VARCHAR > 1333 bytes, OR just 1 VARCHAR > 1333 bytes in the table, you cannot hit this problem. The following query will give you all the tables with such a combination of
columns:
SELECT * FROM
(SELECT TABLE_NAME, OWNER, count(*) NUM
FROM DBA_TAB_COLUMNS
WHERE DATA_TYPE='LONG'
OR (( DATA_TYPE='VARCHAR2'
or DATA_TYPE='CHAR'
or DATA_TYPE='NVARCHAR2'
or DATA_TYPE='NCHAR')
AND DATA_LENGTH > 1333)
AND OWNER NOT IN
('SYS','SYSTEM','SH','OLAPSYS','MDSYS','WKSYS','ODM','XDB','WMSYS')
GROUP BY TABLE_NAME, OWNER)
WHERE NUM > 1;
(by default this statement filters out the standard schema's that should not contain any user data, you can change that if needed)
These tables will have to be looked at. You need to decide if you can decrease the size of the (VAR)CHARs to 1333 bytes or less. Because you should hit this bug before production (in either development or testing) it should not take to long to determine if this is something that can be done and it should certainly not take too long to implement if it's decided to do so.
If you run into this problem because you have defined strings bigger than "VARCHAR2(444 CHAR)" then in most cases you should be able to redefine them as "VARCHAR2(1333 BYTE)" without loosing much of the lengths of the strings you can store. In practice it will not happen a lot that all characters you store in a string will use the full 3 bytes of storage. So, for example, if you tried to define a "VARCHAR2(1000 CHAR)" you could run into this problem. If you change that to "VARCHAR2(1333 BYTE)" you will in practice still be able to store around 1000 characters (for languages based on ASCII).
4. Do not use the multibyte character set as the database character set This is usually not a option if you hit this issue on JA16SJIS or JA16EUC, because there are no single-byte alternatives for this. However, if you store European or Arabic characters in a (AL32)UTF8 database and hit this problem then it could be an alternative to use a single byte character set. However, it is still better and usually easier to use one of the earlier mentioned workarounds than it is to go back to a single byte character set. Certainly if you hit this problem when you're developing a new application then the other 3 workarounds are the preferred option and it should certainly be possible to use either of those. In a scenario where you're changing character sets from an existing database and where the application does not change dramatically it could be difficult to use workaround 1 or 2. In that case workaround 3 should certainly be investigated.
Something to keep in mind is that if you're changing to a UTF8 database you can really only make full use of the new possibilities if your client also starts to use a Unicode character set. For example if you have a ANSI application that always runs on Western European Windows machines, changing to UTF8 storage wouldn't add any extra characters because the application can't handle them anyway. So changing the application into Unicode and using workaround 1 would really be the best option.
Fixes
In Oracle8i and Oracle9i this is a limitation for which you need to use one of the workarounds. This problem is 'fixed' in Oracle 10i. Because of the change in architecture that is required, this behavior will not change for Oracle8i and Oracle9i.
References
Bug 1400539 - Getting Ora-1461 When Inserting Into A Varchar Field Bug 1538990 - Ora-1461 When Inserting And Updating To Db(Sjis) From Client(Euc) Bug 2909286 - Ora-1461 Generated On Insert In Proc To A Utf-8 Database Bug 2998709 - Ora-01461: Can Bind A Long Value Only For Insert Into A Long Column Note 158577.1 - NLS_LANG Explained (How does Client-Server Character Conversion Work?) Note 179133.1 - The correct NLS_LANG in a Windows Environment Note 225912.1 - Changing the Database Character Set - a short overview Note 101578.1 - Example: OCI 8i Example on UCS2-encoding Note 223025.1 - Truncation of multi-byte characters within an OCI application. Note 60134.1 - Globalization (NLS) - Frequently Asked Questions Note 267942.1 - Globalization Technology (NLS) Knowledge Browser Product Page
Errors
ORA-1461 <http://metalink.oracle.com/metalink/plsql/ml2_gui.handleSearchRequest?p_search=Submit&p_text=ORA-1461> can bind a LONG value only for insert into a LONG column
Key Facts
'MULTIBYTE <http://metalink.oracle.com/metalink/plsql/ml2_gui.handleSearchRequest?p_search=Submit&p_text='KEYWORD:MULTIBYTE'> ' 'AL32UTF8 <http://metalink.oracle.com/metalink/plsql/ml2_gui.handleSearchRequest?p_search=Submit&p_text='KEYWORD:AL32UTF8'> ' 'CHARACTER <http://metalink.oracle.com/metalink/plsql/ml2_gui.handleSearchRequest?p_search=Submit&p_text='KEYWORD:CHARACTER'> ' 'CONVERSIONRATIO <http://metalink.oracle.com/metalink/plsql/ml2_gui.handleSearchRequest?p_search=Submit&p_text='KEYWORD:CONVERSIONRATIO'> ' 'NLS_LANG <http://metalink.oracle.com/metalink/plsql/ml2_gui.handleSearchRequest?p_search=Submit&p_text='KEYWORD:NLS_LANG'> ' 'ORA-1461 <http://metalink.oracle.com/metalink/plsql/ml2_gui.handleSearchRequest?p_search=Submit&p_text='KEYWORD:ORA-1461'> '
well hey there guys, i've been looking all over the internet for a GOOD black hat SEO forum.. I was looking for some suggestions
from you guys to point me in the right direction.
Thanks a bunch, this place is great btw.
作者 eixaldaSnowxie — 05 02 2010, 04:55
Aloha! kamagra
作者 kamagra — 30 05 2010, 04:10
Aloha! kamagra
作者 kamagra — 30 05 2010, 04:17
Aloha! accutane
作者 accutane — 30 05 2010, 05:05
Aloha! diovan
作者 diovan — 30 05 2010, 05:17
Aloha! kamagra
作者 kamagra — 30 05 2010, 05:58
Aloha! kamagra
作者 kamagra — 30 05 2010, 16:09
Aloha! kamagra
作者 kamagra — 30 05 2010, 16:21
Aloha! commander kamagra
作者 commander kamagra — 30 05 2010, 19:50
Aloha! cheapest viagra
作者 cheapest viagra — 31 05 2010, 01:41
Aloha! accutane
作者 accutane — 31 05 2010, 05:00
Aloha! kamagra
作者 kamagra — 31 05 2010, 05:56
Aloha! alprazolam without prescription
作者 alprazolam without prescription — 31 05 2010, 13:50
Aloha! kamagra
作者 kamagra — 31 05 2010, 15:51
Aloha! kamagra
作者 kamagra — 31 05 2010, 15:57
Aloha! diovan
作者 diovan — 31 05 2010, 16:41
Aloha! diovan
作者 diovan — 31 05 2010, 17:19
Aloha! kamagra
作者 kamagra — 31 05 2010, 17:24
Aloha! buy alprazolam without prescription
作者 buy alprazolam without prescription — 01 06 2010, 00:21
Aloha! accutane
作者 accutane — 01 06 2010, 04:33
Aloha! diovan generic
作者 diovan generic — 01 06 2010, 05:03
Aloha! buy diovan
作者 buy diovan — 01 06 2010, 05:59
Aloha! alprazolam online without prescription
作者 alprazolam online without prescription — 01 06 2010, 13:45
Aloha! diovan
作者 diovan — 02 06 2010, 03:31
Aloha! alprazolam
作者 alprazolam — 02 06 2010, 03:54
Aloha! kamagra oral jelly 100mg
作者 kamagra oral jelly 100mg — 02 06 2010, 05:32
Aloha! fioricet online
作者 fioricet online — 02 06 2010, 12:12
Aloha! kamagra soft tabs
作者 kamagra soft tabs — 02 06 2010, 18:11
Aloha! fioricet no prescription
作者 fioricet no prescription — 02 06 2010, 18:25
Aloha! diovan online
作者 diovan online — 02 06 2010, 19:31
Aloha! order fioricet online
作者 order fioricet online — 03 06 2010, 08:27
Aloha! kamagra soft tabs
作者 kamagra soft tabs — 03 06 2010, 10:53
Aloha! comprare kamagra
作者 comprare kamagra — 03 06 2010, 11:25
Aloha! commander kamagra
作者 commander kamagra — 03 06 2010, 12:07
Aloha! fioricet
作者 fioricet — 03 06 2010, 19:36
Aloha! commander kamagra
作者 commander kamagra — 03 06 2010, 19:47
Aloha! buy diovan
作者 buy diovan — 03 06 2010, 20:30
Aloha! generic diovan
作者 generic diovan — 04 06 2010, 01:33
Aloha! kamagra
作者 kamagra — 04 06 2010, 01:51
Aloha! generic diovan
作者 generic diovan — 04 06 2010, 05:53
Aloha! achat kamagra oral jelly
作者 achat kamagra oral jelly — 04 06 2010, 11:35
Aloha! commander kamagra
作者 commander kamagra — 04 06 2010, 14:18
Aloha! hydrocodone no prescription
作者 hydrocodone no prescription — 04 06 2010, 14:22
Aloha! achat kamagra oral jelly
作者 achat kamagra oral jelly — 04 06 2010, 20:20
Aloha! accutane
作者 accutane — 04 06 2010, 21:14
Aloha! hydrocodone
作者 hydrocodone — 04 06 2010, 23:19
Aloha! kamagra
作者 kamagra — 05 06 2010, 07:20
Aloha! kamagra oral jelly kaufen
作者 kamagra oral jelly kaufen — 05 06 2010, 12:33
Aloha! kamagra oral jelly kaufen
作者 kamagra oral jelly kaufen — 05 06 2010, 12:48
Aloha! diovan online
作者 diovan online — 05 06 2010, 22:16
Aloha! kamagra
作者 kamagra — 06 06 2010, 05:20
Aloha! kamagra oral jelly kaufen
作者 kamagra oral jelly kaufen — 06 06 2010, 09:29
Aloha! diovan generic
作者 diovan generic — 06 06 2010, 17:57
Aloha! generic diovan
作者 generic diovan — 07 06 2010, 05:56
Aloha! achat kamagra oral jelly
作者 achat kamagra oral jelly — 07 06 2010, 06:07
Aloha! diovan
作者 diovan — 07 06 2010, 11:20
Aloha! kamagra oral jelly kaufen
作者 kamagra oral jelly kaufen — 07 06 2010, 13:15
Aloha! diovan online
作者 diovan online — 07 06 2010, 16:03
Aloha! kamagra oral jelly kaufen
作者 kamagra oral jelly kaufen — 07 06 2010, 18:00
Aloha! diovan
作者 diovan — 08 06 2010, 01:40
Aloha! commander kamagra
作者 commander kamagra — 08 06 2010, 03:45
Aloha! diovan generic
作者 diovan generic — 08 06 2010, 11:04
Aloha! kamagra oral jelly kaufen
作者 kamagra oral jelly kaufen — 08 06 2010, 12:47
Aloha! kamagra kaufen
作者 kamagra kaufen — 08 06 2010, 20:05
Aloha! buy diovan
作者 buy diovan — 08 06 2010, 21:47
Aloha! kamagra kaufen
作者 kamagra kaufen — 09 06 2010, 02:12
Aloha! diovan online
作者 diovan online — 09 06 2010, 10:17
Aloha! generic diovan
作者 generic diovan — 09 06 2010, 10:43
Aloha! buy diovan
作者 buy diovan — 10 06 2010, 13:22
Aloha! generic diovan
作者 generic diovan — 11 06 2010, 00:00
Aloha! hydrocodone
作者 hydrocodone — 11 06 2010, 01:42
Aloha! viagra
作者 viagra — 11 06 2010, 02:26
Aloha! diovan generic
作者 diovan generic — 12 06 2010, 14:23
Aloha! commander kamagra
作者 commander kamagra — 12 06 2010, 14:43
Aloha! hydrocodone
作者 hydrocodone — 12 06 2010, 14:44
Aloha! commander kamagra
作者 commander kamagra — 12 06 2010, 15:01
Aloha! hydrocodone online prescription
作者 hydrocodone online prescription — 12 06 2010, 15:09
Aloha! alprazolam without prescription
作者 alprazolam without prescription — 12 06 2010, 23:49
Aloha! alprazolam without prescription
作者 alprazolam without prescription — 13 06 2010, 02:07
Aloha! kamagra oral jelly kaufen
作者 kamagra oral jelly kaufen — 13 06 2010, 04:45
Aloha! commander kamagra
作者 commander kamagra — 13 06 2010, 06:19
Aloha! commander kamagra
作者 commander kamagra — 13 06 2010, 06:35
Aloha! commander kamagra
作者 commander kamagra — 13 06 2010, 12:26
Aloha! hydrocodone
作者 hydrocodone — 13 06 2010, 12:50
Aloha! buy hydrocodone without prescription
作者 buy hydrocodone without prescription — 13 06 2010, 13:17
Aloha! hydrocodone
作者 hydrocodone — 13 06 2010, 13:33
Aloha! buy alprazolam without prescription
作者 buy alprazolam without prescription — 13 06 2010, 21:40
Aloha! buy alprazolam without prescription
作者 buy alprazolam without prescription — 13 06 2010, 23:56
Aloha! commander kamagra
作者 commander kamagra — 14 06 2010, 04:35
Aloha! buy hydrocodone without prescription
作者 buy hydrocodone without prescription — 14 06 2010, 12:33
Aloha! alprazolam online without prescription
作者 alprazolam online without prescription — 14 06 2010, 20:56
Aloha! alprazolam online without prescription
作者 alprazolam online without prescription — 14 06 2010, 23:52
Aloha! commander kamagra
作者 commander kamagra — 15 06 2010, 09:37
Aloha! hydrocodone
作者 hydrocodone — 15 06 2010, 23:49
Aloha! buy alprazolam without prescription
作者 buy alprazolam without prescription — 17 06 2010, 14:28
Aloha! commander kamagra
作者 commander kamagra — 17 06 2010, 16:26
Aloha! alprazolam online without prescription
作者 alprazolam online without prescription — 18 06 2010, 13:12
12]鲥睇 桧蜩
作者 ssqpdktocv — 18 06 2010, 21:12
12]礤趄妣汔眈
作者 gxdpzaglccl — 18 06 2010, 22:39
Aloha! kamagra
作者 kamagra — 19 06 2010, 07:41
Aloha! buy alprazolam without prescription
作者 buy alprazolam without prescription — 20 06 2010, 01:02
i'am glad fo find this place, i love tv shows ,games:)
What are the health and safety implications of the...
作者 Weereesip — 20 06 2010, 03:05
Aloha! buy alprazolam without prescription
作者 buy alprazolam without prescription — 20 06 2010, 03:29
Aloha! commander kamagra
作者 commander kamagra — 20 06 2010, 05:26
Aloha! diovan generic
作者 diovan generic — 20 06 2010, 06:09
Aloha! alprazolam online without prescription
作者 alprazolam online without prescription — 20 06 2010, 22:11
12]珥嚓铎耱忄
作者 kvkitmpxffwd — 21 06 2010, 07:44
Aloha! diovan online
作者 diovan online — 21 06 2010, 07:50
12]珥嚓铎耱忸
作者 logrzkxh — 21 06 2010, 10:21
12]徉腧
作者 gngekwst — 21 06 2010, 11:42
Aloha! buy hydrocodone without prescription
作者 buy hydrocodone without prescription — 21 06 2010, 13:16
12]牦徉眈觇
作者 byimereujzrq — 21 06 2010, 17:09
Aloha! accutane
作者 accutane — 22 06 2010, 02:19
Aloha! alprazolam without prescription
作者 alprazolam without prescription — 22 06 2010, 04:35
Aloha! diovan
作者 diovan — 22 06 2010, 07:52
Aloha! diovan
作者 diovan — 22 06 2010, 22:11
Aloha! buy diovan
作者 buy diovan — 23 06 2010, 00:53
Aloha! accutane online
作者 accutane online — 24 06 2010, 20:01
Aloha! levitra
作者 levitra — 24 06 2010, 23:48
Aloha! hydrocodone online prescription
作者 hydrocodone online prescription — 25 06 2010, 00:27
Aloha! kamagra
作者 kamagra — 25 06 2010, 00:43
Aloha! levitra
作者 levitra — 25 06 2010, 01:05
Aloha! accutane
作者 accutane — 25 06 2010, 01:23
Aloha! kamagra
作者 kamagra — 25 06 2010, 02:41
Aloha! buy accutane
作者 buy accutane — 25 06 2010, 03:11
Aloha! commander kamagra
作者 commander kamagra — 25 06 2010, 03:40
Aloha! commander kamagra
作者 commander kamagra — 25 06 2010, 04:56
Aloha! hydrocodone
作者 hydrocodone — 25 06 2010, 08:02
Aloha! levitra
作者 levitra — 25 06 2010, 08:04
Aloha! diovan online
作者 diovan online — 25 06 2010, 08:21
Aloha! hydrocodone
作者 hydrocodone — 25 06 2010, 09:24
Aloha! kamagra
作者 kamagra — 25 06 2010, 10:29
Aloha! kamagra
作者 kamagra — 25 06 2010, 12:54
Aloha! buy diovan
作者 buy diovan — 25 06 2010, 13:42
Aloha! diovan
作者 diovan — 25 06 2010, 15:07
Aloha! azithromicyn
作者 azithromicyn — 25 06 2010, 16:41
Aloha! generic diovan
作者 generic diovan — 25 06 2010, 16:56
Aloha! kamagra
作者 kamagra — 25 06 2010, 17:07
Aloha! kamagra
作者 kamagra — 25 06 2010, 17:58
Aloha! ativan
作者 ativan — 25 06 2010, 18:39
Aloha! hydrocodone online
作者 hydrocodone online — 25 06 2010, 20:58
Aloha! kamagra
作者 kamagra — 25 06 2010, 21:49
Aloha! diovan
作者 diovan — 25 06 2010, 21:54
Aloha! hydrocodone no prescription
作者 hydrocodone no prescription — 26 06 2010, 03:28
Aloha! kamagra
作者 kamagra — 26 06 2010, 07:21
Aloha! hydrocodone
作者 hydrocodone — 26 06 2010, 07:51
Aloha! buy accutane online
作者 buy accutane online — 26 06 2010, 15:35
Aloha! diovan online
作者 diovan online — 26 06 2010, 15:54
Aloha! hydrocodone online prescription
作者 hydrocodone online prescription — 26 06 2010, 17:17
Aloha! viagra
作者 viagra — 26 06 2010, 19:52
Aloha! hydrocodone no prescription
作者 hydrocodone no prescription — 26 06 2010, 20:35
Aloha! kamagra
作者 kamagra — 27 06 2010, 03:13
Aloha! hydrocodone
作者 hydrocodone — 27 06 2010, 04:23
Aloha! accutane online
作者 accutane online — 27 06 2010, 15:28
Aloha! buy hydrocodone without prescription
作者 buy hydrocodone without prescription — 27 06 2010, 17:46
Aloha! buy diovan
作者 buy diovan — 27 06 2010, 21:05
Aloha! hydrocodone
作者 hydrocodone — 28 06 2010, 04:19
Aloha! commander kamagra
作者 commander kamagra — 28 06 2010, 11:34
Aloha! buy accutane
作者 buy accutane — 28 06 2010, 15:24
Aloha! hydrocodone online
作者 hydrocodone online — 28 06 2010, 15:40
Aloha! hydrocodone no prescription
作者 hydrocodone no prescription — 29 06 2010, 04:08
Aloha! hydrocodone online prescription
作者 hydrocodone online prescription — 30 06 2010, 06:29
Aloha! kamagra soft tabs
作者 kamagra soft tabs — 30 06 2010, 21:53
Aloha! kamagra soft tabs
作者 kamagra soft tabs — 01 07 2010, 01:18
Aloha! azithromycin
作者 azithromycin — 01 07 2010, 22:39
Aloha! alprazolam without prescription
作者 alprazolam without prescription — 02 07 2010, 04:08
Aloha! viagra
作者 viagra — 02 07 2010, 06:48
Aloha! generic diovan
作者 generic diovan — 02 07 2010, 07:01
Aloha! commander kamagra
作者 commander kamagra — 02 07 2010, 07:36
Aloha! kamagra oral jelly
作者 kamagra oral jelly — 02 07 2010, 08:44
Aloha! azithromycin
作者 azithromycin — 03 07 2010, 16:35
Aloha! buy alprazolam without prescription
作者 buy alprazolam without prescription — 03 07 2010, 16:37
Aloha! buy accutane online
作者 buy accutane online — 03 07 2010, 18:58
Aloha! alprazolam without prescription
作者 alprazolam without prescription — 04 07 2010, 14:52
Aloha! viagra
作者 viagra — 05 07 2010, 02:09
Aloha! alprazolam without prescription
作者 alprazolam without prescription — 05 07 2010, 03:46
Aloha! kamagra
作者 kamagra — 05 07 2010, 04:07
Aloha! azithromycin
作者 azithromycin — 05 07 2010, 13:10
Aloha! kamagra oral jelly
作者 kamagra oral jelly — 05 07 2010, 14:12
Aloha! buy accutane
作者 buy accutane — 05 07 2010, 15:10
Aloha! buy alprazolam without prescription
作者 buy alprazolam without prescription — 06 07 2010, 00:00
Aloha! kamagra oral jelly
作者 kamagra oral jelly — 06 07 2010, 01:38
Aloha! alprazolam online without prescription
作者 alprazolam online without prescription — 06 07 2010, 19:51
Aloha! commander kamagra
作者 commander kamagra — 07 07 2010, 02:58
Aloha! buy accutane online
作者 buy accutane online — 07 07 2010, 03:18
Aloha! diazepam
作者 diazepam — 07 07 2010, 03:28
Aloha! nolvadex
作者 nolvadex — 07 07 2010, 05:53
Aloha! alprazolam without prescription
作者 alprazolam without prescription — 07 07 2010, 10:09
Aloha! diazepam
作者 diazepam — 07 07 2010, 16:34
Aloha! nolvadex online
作者 nolvadex online — 07 07 2010, 20:14
Aloha! hydrocodone online prescription
作者 hydrocodone online prescription — 07 07 2010, 23:28
Aloha! buy alprazolam without prescription
作者 buy alprazolam without prescription — 08 07 2010, 06:52
Aloha! hydrocodone
作者 hydrocodone — 08 07 2010, 08:11
Aloha! hydrocodone no prescription
作者 hydrocodone no prescription — 08 07 2010, 08:55
Aloha! hydrocodone
作者 hydrocodone — 08 07 2010, 09:27
Aloha! nolvadex
作者 nolvadex — 08 07 2010, 14:06
Aloha! diazepam
作者 diazepam — 08 07 2010, 18:38
Aloha! hydrocodone
作者 hydrocodone — 08 07 2010, 23:30
Aloha! hydrocodone
作者 hydrocodone — 09 07 2010, 04:24
Aloha! hydrocodone online
作者 hydrocodone online — 09 07 2010, 06:23
Aloha! buy nolvadex online
作者 buy nolvadex online — 09 07 2010, 09:51
Aloha! hydrocodone online
作者 hydrocodone online — 09 07 2010, 11:20
Aloha! buy hydrocodone without prescription
作者 buy hydrocodone without prescription — 09 07 2010, 19:42
Aloha! hydrocodone online prescription
作者 hydrocodone online prescription — 09 07 2010, 22:53
Aloha! alprazolam without prescription
作者 alprazolam without prescription — 10 07 2010, 01:54
Aloha! hydrocodone no prescription
作者 hydrocodone no prescription — 10 07 2010, 03:34
Aloha! hydrocodone no prescription
作者 hydrocodone no prescription — 10 07 2010, 04:34
Aloha! buy hydrocodone without prescription
作者 buy hydrocodone without prescription — 10 07 2010, 09:28
Aloha! fioricet
作者 fioricet — 10 07 2010, 15:27
Aloha! hydrocodone
作者 hydrocodone — 11 07 2010, 03:59
Aloha! achat kamagra oral jelly
作者 achat kamagra oral jelly — 11 07 2010, 10:14
Aloha! commander kamagra
作者 commander kamagra — 11 07 2010, 14:32
Aloha! fioricet
作者 fioricet — 11 07 2010, 21:49
Aloha! hydrocodone online prescription
作者 hydrocodone online prescription — 12 07 2010, 02:41
Aloha! commander kamagra
作者 commander kamagra — 12 07 2010, 08:27
Aloha! hydrocodone online
作者 hydrocodone online — 12 07 2010, 11:21
Aloha! buy fioricet
作者 buy fioricet — 12 07 2010, 13:45
Aloha! hydrocodone
作者 hydrocodone — 12 07 2010, 22:46
Aloha! fioricet
作者 fioricet — 13 07 2010, 00:00
Aloha! achat kamagra oral jelly
作者 achat kamagra oral jelly — 13 07 2010, 10:19
Aloha! commander kamagra
作者 commander kamagra — 13 07 2010, 21:42
Aloha! hydrocodone no prescription
作者 hydrocodone no prescription — 14 07 2010, 03:56
Aloha! fioricet without prescription
作者 fioricet without prescription — 14 07 2010, 04:36
Aloha! buy hydrocodone without prescription
作者 buy hydrocodone without prescription — 14 07 2010, 04:48
Aloha! hydrocodone
作者 hydrocodone — 14 07 2010, 08:44
Aloha! fioricet
作者 fioricet — 14 07 2010, 08:57
Aloha! fioricet online
作者 fioricet online — 14 07 2010, 09:05
Aloha! achat kamagra oral jelly
作者 achat kamagra oral jelly — 14 07 2010, 15:02
Aloha! hydrocodone online prescription
作者 hydrocodone online prescription — 14 07 2010, 19:43
Aloha! kamagra
作者 kamagra — 14 07 2010, 21:00
Aloha! kamagra
作者 kamagra — 15 07 2010, 08:08
Aloha! buy hydrocodone without prescription
作者 buy hydrocodone without prescription — 15 07 2010, 09:37
Aloha! hydrocodone online
作者 hydrocodone online — 15 07 2010, 13:21
Aloha! hydrocodone
作者 hydrocodone — 16 07 2010, 00:25
Aloha! hydrocodone no prescription
作者 hydrocodone no prescription — 16 07 2010, 01:18
Aloha! hydrocodone
作者 hydrocodone — 16 07 2010, 04:28
Aloha! achat kamagra oral jelly
作者 achat kamagra oral jelly — 16 07 2010, 05:40
Aloha! znxnc bxvab
作者 Gundosxjv — 16 07 2010, 22:32
Aloha! hydrocodone online prescription
作者 hydrocodone online prescription — 17 07 2010, 01:48
Aloha! hydrocodone
作者 hydrocodone — 17 07 2010, 04:37
Aloha! hydrocodone
作者 hydrocodone — 17 07 2010, 16:53
Aloha! buy hydrocodone without prescription
作者 buy hydrocodone without prescription — 17 07 2010, 18:25
Aloha! buy hydrocodone without prescription
作者 buy hydrocodone without prescription — 18 07 2010, 00:03
Aloha! hydrocodone online
作者 hydrocodone online — 18 07 2010, 02:15
Aloha! hydrocodone online
作者 hydrocodone online — 18 07 2010, 07:53
Aloha! hydrocodone
作者 hydrocodone — 19 07 2010, 12:08
Aloha! acheter kamagra 100mg
作者 acheter kamagra 100mg — 20 07 2010, 10:05
Aloha! acheter kamagra 100mg
作者 acheter kamagra 100mg — 20 07 2010, 10:47
Aloha! kamagra deutschland
作者 kamagra deutschland — 20 07 2010, 11:14
Aloha! accutane online
作者 accutane online — 21 07 2010, 07:27
Aloha! buy hydrocodone without prescription
作者 buy hydrocodone without prescription — 22 07 2010, 01:49